Hi all, I am trying to show in a pivot table the data for a selected month along with YTD up to that month, that month for last year, and YTD up to that month for last year.
I can make whatever changes are necessary in Power Query and believe that a DAX measure would be best here.
I can change the data source to show MMM YYYY, month numbers, etc if that helps.
Please see small representative sample attached.
Bookmarks