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.
I am using this expression in filter part of calculate function:
However Power BI doesn't calculate it and gives this error:
"A function 'FIRSTDATE' has been used in a True/False expression that is used as a table filter expression. This is not allowed."
I'm just trying to compare the first date with another date and don't understand what is wrong here. Is there something to be corrected or a workaround to be used?
Solved! Go to Solution.
@VilleMasa , for the first date of last month
eomonth('Calendar'[date],-2)+1
In case of measure you might have to use
eomonth(max('Calendar'[date]) ,-2)+1
@VilleMasa , for the first date of last month
eomonth('Calendar'[date],-2)+1
In case of measure you might have to use
eomonth(max('Calendar'[date]) ,-2)+1
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 |
---|---|
47 | |
24 | |
20 | |
14 | |
12 |
User | Count |
---|---|
55 | |
48 | |
43 | |
19 | |
18 |