Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

DAX CALCULATION

I'm trying to GM % on a row based. Net GP/Sales. Please can someone help me.   
Need Help
amitchandak's avatar
amitchandak
Super User
4 years ago

Anonymous , And you do not have Baked Good in another column, you want it to also be searched and created a GP?

 

My Idea would be to split this column from behind in power bi

first by (

then by space - Before doing the I will replace sales with net sales so I can split on 2nd space from last

 

If I am on the right path, I need a sample to work on.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

The Baked goods are attribute on line Description. I need to Divide 
Baked goods Net GP/ Baked goods sales Using the Actuals & Budget meassures. So it will Populate Baked Goods gross margin row based. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    amitchandak I'm trying to used SelectedValue & Switch function. This is how the actuals & Budget was Calculated. 

     

    • amitchandak's avatar
      amitchandak
      Super User
      4 years ago

      Anonymous , what is the difference in the measure? for each switch value.  I think, need to look into details, what was needed and why the above was needed

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        amitchandak  What was needed is the GM % from Acutal & Budget Values. Divide 541,093.85/2,036,933.92 = Baked Good Gross Margin. Every line descriptioin has a Gross Margin attribute Users wants fill in those gross margin attribute.