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've created a measure to calculate another measure only for dates before a particular date.
i.e. CALCULATE( [measure] , [date] < 01/09/2019)
But my result is coming up as blank. Can someone tell me what is wrong with this formula? Reason for this formula is that I want to create a measure for before and after this date and then calculate the difference between these.
Solved! Go to Solution.
Hi @bo_afk ,
CALCULATE needs two kinds of parameter: Expression and Filter. So you need a table range to get a filter.
So you could try the following DAX:
Measure =
CALCULATE ( [measure], FILTER ( 'Table', [date] < DATE ( 2019, 1, 9 ) ) )
Hi @bo_afk ,
CALCULATE needs two kinds of parameter: Expression and Filter. So you need a table range to get a filter.
So you could try the following DAX:
Measure =
CALCULATE ( [measure], FILTER ( 'Table', [date] < DATE ( 2019, 1, 9 ) ) )
Hi @bo_afk ,
I'm not totally sure because dates are always something tricky 😁.
Try to format it inside DATE function I think that would pass it with no problems.
Let me know if it helped.
BR,
DR
Thanks for your suggestion @Anonymous
I did try using the date function but it didn't seem to work. I suspect that's because it outputs a datetime format and my data has only date. I think tried to format it as "dd/mm/yyyy" but then got an error that I can't compare date values with text.
Update: so the date function works when I use a simple sum as my calculation, but when I input my measure, it doesn't work. Must be an issue with my measure then.
Most likely, I would need some sample data to make a few tests but that usually work.
In general, does the calculate formula work with measures and dates?
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 |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |