I’m having trouble dividing my data by month, YTD, and PYTD.
This is what the source data table looks like. I need to divide the data columns on "Actual", "Budget" and "Diff" into Month, YTD, and the previous year's YTD for comparison.
This is close to what I need except the data is separated to two different tables which does not look good. 2021 being the previous year to YTD.
This is what I tried which did not work. This is my first time using DAX so any help would be appreciated.