DAX formula to divide one row value with another particular row value

[srasel]

Hello All:

I need your help to figure out a DAX formula. I have a table in the left with columns - Project Name, Level 2 & Value. Now need to define a DAX measure to find the value of Gross Profit Margin. The rule is: for each group (Project Name), Gross Profit Margin = (Gross Profit value / Revenue value)

Thank you in advance.

Regards,

rasel

[Anonymous · Accepted solution]

Hi @srasel,

Why not pivot the Level 2 column in Query Editor shown in the following screenshot and then create a new column using the following formula?

NewColumn = Table1[Gross Profit]/Table1[Revenue]



You can check the values of new column in the figure below, for more details, you can review the example in the attached PBIX file.




Thanks,
Lydia Zhang

[srasel]

Hello @Anonymous:

Thank you! Restructuring the data like that will work I guess. Let me try that on my input set. Hope that will work there too.

Thank you once again. Really appreciat that.

Regards,

rasel