cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
harieee
Frequent Visitor

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

2 REPLIES 2
amitchandak
Super User
Super User

@harieee , Try a measure like

 

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



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

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

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!