Please help in forming the below table structure in PowerBI
I have a table structure which is:
And I want to convert it into the below sample shown:
Why I am trying to achieve the above feat is that I want to map all the possible years and years-period to the corresponding years and years- period except itself. Further allocating the previous year as the last year (in this case 2019) and the years-period as "FY Actuals". Above thing, I tried to achieve by "CROSS JOIN" but it takes a whole lot of time to get executed.
But Once I achieved it then again I did a "CROSS JOIN" to get the mapping of period and quarters.
After that, for example, if the period lets say CC is 202006 then the P01-P05 should be "YTD" and rest as "YTG". But if it is "FY Actuals" flag for P01-P13 should be "YTG".
I am attaching the excel sheet for a better understanding of the user. Please let me know if further explanation is required.