Power Pivot year to date across years

%3CLINGO-SUB%20id%3D%22lingo-sub-2571832%22%20slang%3D%22en-US%22%3EPower%20Pivot%20year%20to%20date%20across%20years%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2571832%22%20slang%3D%22en-US%22%3EHi%20all!%3CBR%20%2F%3EI%20am%20wanting%20to%20have%20a%20pivot%20table%20with%20columns%20being%20Years%2FQtrs%2FMonths%20and%20rows%20being%20some%20categories%20in%20my%20data%3CBR%20%2F%3E%3CBR%20%2F%3EI%20have%20a%20calendar%20table%20set%20up%20and%20have%20custom%20columns%20for%20Year%2FQtr%2FMonth%2FWeek%20offsets%20from%20current%20date%20(if%20that%20helps%20in%20your%20answer)%3CBR%20%2F%3E%3CBR%20%2F%3EI%20am%20wanting%20to%20show%20year%20to%20date%20dynamic%20data%20from%20what%20the%20current%20date%20is%E2%80%A6.%3CBR%20%2F%3E%3CBR%20%2F%3EFor%20example%20I%20want%20to%20show%20the%20data%20for%201-7%20months%20for%202018%202019%202020%20and%202021%20then%20next%20month%20show%201-8%20months%20etc%3CBR%20%2F%3E%3CBR%20%2F%3ECan%20anyone%20assist%20with%20how%20I%20would%20accomplish%20this%20with%20power%20pivot%3F%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2571832%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2572655%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Pivot%20year%20to%20date%20across%20years%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2572655%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F941988%22%20target%3D%22_blank%22%3E%40jfielder%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EQuite%20close%20to%20your%20case%20pattern%20is%20here%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fwww.daxpatterns.com%2Fcumulative-total%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3ECumulative%20total%20%E2%80%93%20DAX%20Patterns%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor
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?
1 Reply

@jfielder 

Quite close to your case pattern is here Cumulative total – DAX Patterns