Forum Discussion
DAX CALCULATION
amitchandak 541,093.85/2,036,933,92 = Baked Good Gross Margin only
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.
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.amitchandak I'm trying to used SelectedValue & Switch function. This is how the actuals & Budget was Calculated.
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