what is the easiest/ most efficient way to create variance for different rows?

[Anonymous]

I would like to create variance but my data stored in rows instead of columns. previously  in Ms Excel was easy to create a pivot and make a calculation using different column.

in PowerBI I have 1 row for revenue and 1 row for cost. I would like to create the margin using the revenue-cost formula, but im not aware what would be the easiest and calc view the fastest way to create it? where should I look at it?

please note:

Im a rookie in PowerBI

[ibarrau]

Hi. I don't think you should work like that at all. You can transform your data in Power Bi to work with columns instead of rows because power bi works with columns.

Try unpivot like this post showing both actions:

https://databear.com/power-bi-pivot-and-unpivot-columns/

Then you can work with columns again. I don't recommend working with rows.

Regards,

[az38]

Hi @Anonymous 

there are Pivot and Unpivot functions in Power Query Editor mode