Static Row Headers with calculated row values

Question

Hello, newer user ro power bi desktop coming from Qlik Sense.&nbsp; In Qlik I was able to create a table with what I call static row headers and a row of calcualted fields.&nbsp; Here is what I am trying to accomplish, this is just a made up sample visual table.&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Current Year&nbsp; &nbsp; &nbsp;Prior Year&nbsp; &nbsp; &nbsp;Year Over Year ChangeReturns&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 50&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;40&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10Sales&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;125&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;105&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;20&nbsp;Shipped&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 45&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;30&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 15&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;The first column Returns, Sales, and Shipped are static values that just describe the row of data.&nbsp; The other 3 columns are calculated values. Any help would greatly be appreciated.

anonymous · Accepted Answer

Hi&nbsp;appsac1&nbsp;,
&nbsp;
I need to know where your data in three columns come from, a data table or you just want to create a calculated table?
If you want to create a calculated table in Power BI, you can try this code.
Table = 
DATATABLE(
    "static row headers",STRING,
    "Current Year",INTEGER,
    "Piror Year",INTEGER,
    "Year Over Year Change",INTEGER,
   {{"Returns","50","40","10"},
    {"Sales","125","105","20"},
    {"Shipped","45","30","15"}
   }
)
Result is as below.

If you want to calcualte based on data in fact table, please share a sample file with me.
&nbsp;
Best Regards,Rico Zhou
&nbsp;
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
&nbsp;
&nbsp;

Forum Discussion

Static Row Headers with calculated row values

1 Reply

Related content

% with static denominator

Paginated Report headers not repeating

Getting static row and corresponding value for row header in matrix

Static QUARTERS calculation

Static Outbound IP for Notebook