• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Calculate % off another row value with a dax formula

Dokat

Member
I have a table name sales and trying to calculate % off gross for each value. I tried numerous dax formulas but couldnt get it to work in Power BI.

Does any one know how to calculate % of Gross for each row in below table in Power BI with dax formula?

Sample
Calendar YearCustomerPL LineValues% of Gross
2019​
ACME MarketsVolume
1972240​
2019​
ACME MarketsGross
697503​
2019​
ACME MarketsReturns
0​
2019​
ACME MarketsDiscounts
3398​
2019​
ACME MarketsOSG
206648​
2019​
ACME MarketsNS
206224​
2019​
ACME MarketsContribution
-109594​
 
Back
Top