Monthly and QTD, YTD, MTD on same Pivot

Anything related to PowerPivot and DAX Formuale
turnbullca
Posts: 49
Joined: Wed Mar 23, 2016 8:24 am

Monthly and QTD, YTD, MTD on same Pivot

Postby turnbullca » Thu Mar 08, 2018 4:50 am

Hi All

I am sure I have seen a tutorial on this but have failed to find it.

Is it possible in Powerpivot Excel 2016 to have monthly and cumulative measures on the same pivot.

eg
Jan Feb March April June July August September October November December MTD QTD YTD
Any pointers gratefully received.

Thanks

Chris

turnbullca
Posts: 49
Joined: Wed Mar 23, 2016 8:24 am

Re: Monthly and QTD, YTD, MTD on same Pivot

Postby turnbullca » Sat Mar 10, 2018 5:04 pm

WOOP WOOP

This is 95% of what I wanted to achieve: viewtopic.php?t=20 so thanks to Rick Wilson.

My only addition is to have multiple measures but on Rows which I cannot seem to achieve.

As always any help is greatfully received.

Thanks

Chris


Return to “PowerPivot/DAX”

Who is online

Users browsing this forum: No registered users and 5 guests