Forum Discussion

Sanskruti's avatar
Sanskruti
Icon for Helper II rankHelper II
3 years ago

DAX for rolling year

Hello,
I have a report in that i have a dim table of date and others are fact table. My requirement is i want to write a dax in which date filter has current date values should be -1 year and the month. I want to do this in date range.
For example:
If the selected date is 22/8/2023 the values should be shown from 1/8/2022.

 

Thank you in advance.

2 Replies

    • Sanskruti's avatar
      Sanskruti
      Icon for Helper II rankHelper II

      Thanks for replying.

      I want to use it on page level. And it should be default.