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

     

v-eachen-msft's avatar
v-eachen-msft
Icon for Community Support rankCommunity Support
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 v-eachen-msft. This looks to have done the trick!