Lay out a single row as a table

[mhomol]

I have a table of period data, with columns of numerical data.  I also 2 more DAX calculated columns for each of these columns, which represent the same field value from a different period row and the difference between the 2.

So my period data looks something like this:

Period	Profit	Last Period Profit %	Diff	Loss	Last Loss %	Diff
Period X	25000	23000	2000	0	1000	(1000)

I have a report that will slice down to a particular period and want a table display that would look like this:

Value	Current	Last	Diff
Profit	25000	23000	2000
Loss	0	1000	(1000)

Is this possible? If so, how do I accomplish?

[amitchandak]

@mhomol , I think you need to check this approch

https://kohera.be/power-bi/how-to-unpivot-twice/

[mhomol]

@amitchandak , this is exactly what we need.  Unfortunately, I am getting the following when trying to unpivot though:

Seems strange that this would be unsupported in SQL or in Dataverse (which is my source).

Is there any way I can get the data to a place where I can successfully unpivot?

[mhomol]

@amitchandak I have a support ticket opened with Microsoft concerning the error above, but this does have me questioning a few things that I'm hoping you can help with. 

Is there not a way to do something like an Unpivot, if I've already created a bunch of calculated fields using DAX that are all working fine prior to the Unpivot? 

Does this mean that I should have done as much of my calculations as possible in Transform Data as Power query m statements instead?  It's very frustrating to do all these DAX calculations only to feel like I will have to redo them on the "Unpivoted source" now.