I want to find an expression equivalent to "SELECT SUM (CASE WHEN YEAR (t.WhenIn) = dimDate.year THEN 1 ELSE 0 END) WhenIn, SUM (CASE WHEN YEAR (t.WhenOut) = dimDate.year THEN 1 ELSE 0 END) WhenOut FROM Test t " in DAX. Thanks in advance.
I want to find an expression equivalent to "SELECT SUM (CASE WHEN YEAR (t.WhenIn) = dimDate.year THEN 1 ELSE 0 END) WhenIn, SUM (CASE WHEN YEAR (t.WhenOut) = dimDate.year THEN 1 ELSE 0 END) WhenOut FROM Test t " in DAX. Thanks in advance.
برچسب:
نویسنده: استخدام کار