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 and show day view or week view as like below.

 

How to get it?

DAX
DAX Calculation

2 Replies

  • 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.