Forum Discussion

powerbiexpert22's avatar
powerbiexpert22
Icon for Impactful Individual rankImpactful Individual
1 year ago
Solved

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: