Forum Discussion

bo_afk's avatar
bo_afk
Icon for Post Patron rankPost Patron
6 years ago
Solved

Measure with calculate before date not working

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 te...
Need Help
  • v-eachen-msft's avatar
    v-eachen-msft
    6 years ago

    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 ) ) )

     

bo_afk's avatar
bo_afk
Icon for Post Patron rankPost Patron
6 years ago

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.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Most likely, I would need some sample data to make a few tests but that usually work.