Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
O.K., this is embarrasing, but this DAX measure ...
select
*
from dbo.FACT_employees_view
where
(status = 'active' and started <= '2021-12-15')
... on MS SQL and it works fine, but here the started column is of text format, changed to Date in PowerBI Column Tools.
Dirk
Solved! Go to Solution.
Hi @MoodyDirk
I think you should wrap the date coumn with the date function for comparision, so the measure would look like
HeadCount = CALCULATE(COUNTROWS('FACT_employees'), 'FACT_employees'[started] <= date(2021,12,15) )
This should work but let us know otherwise...
Thanks,
AnthonyJoseph
Hi @MoodyDirk
I think you should wrap the date coumn with the date function for comparision, so the measure would look like
HeadCount = CALCULATE(COUNTROWS('FACT_employees'), 'FACT_employees'[started] <= date(2021,12,15) )
This should work but let us know otherwise...
Thanks,
AnthonyJoseph
Yes, this works,
Thank You, Anthony.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
46 | |
25 | |
19 | |
16 | |
8 |
User | Count |
---|---|
61 | |
50 | |
45 | |
20 | |
17 |