I took this example from a question I answered on the Microsoft form. The person who posted was having trouble creating a report. This is the data table they were using.
|Statement L1||Statement L2||Order L1||Order L2||Unique Key|
|14. Profit before tax||14. Profit before tax||1||1||1|
|15. CIT||15. CIT||2||2||2|
|16. Deferred tax||16. Deferred tax||3||3||3|
|17. Profit after tax||17. Profit after tax||4||4||4|
|17. Profit after tax||% Profit||4||5||5|
You can see that the data is in the form of a pivot table. There are different columns for the same type of data, like the “statement”, so writing any sort of DAX code or using the data in graphics becomes quite complicated. They were writing measures to extract values from the different columns and then trying to use those values in calculations.
Here is the same data “un-povited”
This data is much easier to work with and some of the graphics they were struggling with just “fell out” when you dragged the fields from the new data onto a pivot table graphic.