Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

filter with datesbetween

hi all,   i am having an issue with creating a table for filter, i believe i am missing something that causes the formula to fail. sample data (date column is proper date in powerBI, below just ...
Need Help
Show and Tell
  • amitchandak's avatar
    amitchandak
    3 years ago

    Anonymous , with help from date table

    example

    Rolling 3 = CALCULATE(sum(Sales[Sales Amount]),DATESINPERIOD('Date'[Date],MAX('Date'[Date]),-3,day))

     

    rolling Days Formula: https://youtu.be/cJVj5nhkKBw

amitchandak's avatar
amitchandak
Super User
3 years ago

Anonymous , with help from date table

example

Rolling 3 = CALCULATE(sum(Sales[Sales Amount]),DATESINPERIOD('Date'[Date],MAX('Date'[Date]),-3,day))

 

rolling Days Formula: https://youtu.be/cJVj5nhkKBw

Anonymous's avatar
Anonymous
Not applicable
3 years ago

works like a charm! thank you amitchandak