Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

DAX filter logic based on slicer date difference

Hi   I have a table where i have date and value. i need to show a slicer for that date column. If user select date in the slicer then need to find the difference days and perform the running total ...
DAX
DAX Calculation
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Anonymous , Try a measure like

 

Cumm = CALCULATE(SUM(Table[value]),filter(allselected(Table),Table[Date] <=max(Table[Date])))

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi amit - Thanks. I have this measure but i need to display the values day wise or week wise based on the difference number.