Forum Discussion

kdrees21's avatar
kdrees21
Helper I
5 years ago

DAX Help Needed

After using this DAX to hide any future month: CALCULATE (<measure>,CALCULATETABLE (<time_intelligence_function> ( 'Date'[Date] ),'Date'[DatesWithSales] = TRUE))   Is there a way to remove the filt...
Help with DAX
Help with DAX Measure
amitchandak's avatar
amitchandak
Super User
5 years ago

kdrees21 , try like

 CALCULATE (<measure>,CALCULATETABLE (<time_intelligence_function> ( 'Date'[Date] ))

or

CALCULATE (<measure>,CALCULATETABLE (<time_intelligence_function> ( 'Date'[Date] ))+0