Forum Discussion
Post PatronMeasure with calculate before date not working
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
Post PatronThanks 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.
- bo_afk
In general, does the calculate formula work with measures and dates?