Forum Discussion
Power Pivot year to date across years
Hi all!
I am wanting to have a pivot table with columns being Years/Qtrs/Months and rows being some categories in my data
I have a calendar table set up and have custom columns for Year/Qtr/Month/Week offsets from current date (if that helps in your answer)
I am wanting to show year to date dynamic data from what the current date is….
For example I want to show the data for 1-7 months for 2018 2019 2020 and 2021 then next month show 1-8 months etc
Can anyone assist with how I would accomplish this with power pivot?
I am wanting to have a pivot table with columns being Years/Qtrs/Months and rows being some categories in my data
I have a calendar table set up and have custom columns for Year/Qtr/Month/Week offsets from current date (if that helps in your answer)
I am wanting to show year to date dynamic data from what the current date is….
For example I want to show the data for 1-7 months for 2018 2019 2020 and 2021 then next month show 1-8 months etc
Can anyone assist with how I would accomplish this with power pivot?
1 Reply
Quite close to your case pattern is here Cumulative total – DAX Patterns
