Forum Discussion
roling 2 months sum based on selection
Hi ,
i am using year and month slicers in my report, i want to display rolling 2 months sum for only those months which are 2 months prior to selected month and including selected month in my table. please see below pbix for reference
https://drive.google.com/file/d/17PyXzGjQzvX3xX13tox-dgeYrkowa6cf/view?usp=drive_link
example1: if user select year as "2024" and month as "may" then table should display months starting from march 2024 until may 2024 along with 2 months rolling sum as shown below
example2: if user select year as "2024" and month as "aug" then table should display months starting from jun 2024 until aug 2024 along with rolling 2 months sum as shown below
example1:
example2:
Hi,
I have solved a similar problem in the attached file. The solution there will definitely solve the first question.
1 Reply
- Ashish_Mathur
Super User
Hi,
I have solved a similar problem in the attached file. The solution there will definitely solve the first question.