Forum Discussion
Anonymous
3 years agoNot applicable
Calculation shows filtered lines
Hi, I have some different data which I all connected to each other with relationships. I want to show data of only the last 3 days on my dashboard. Data1: Date Date 01/01/2008 02...
ERD
3 years agoCommunity Champion
Anonymous , you either need to filter dates on your visual, or include this filtering in your formulas.
- Anonymous3 years agoNot applicable
Thanks for your reply, what is the best way to include this filter in my formula?
- ERD3 years agoCommunity Champion
Something like this:
measure = CALCULATE( your_calculation, Date[Date] <= TODAY () && Date[Date] > TODAY () - 3)You can also try this: https://dax.guide/datesbetween/ .
Today: https://dax.guide/today/.