Forum Discussion
Creating table out of 1 value through DAX
Hello everyone! I have stucked with the dax formulas. Here is the situation: 1. We have only 1 variable value that is used to create all other columns, and two columns to interact with. 2. That on...
Greg_Deckler
Community Champion
Community ChampionOK, let me try a different track, what do you expect the results should be for the data provided? If not 10, then what?
Ok. Maybe it will help. I have some data
I need this data to manipulate with what if parameter in dax, called "Value"
I need this "Value" first be multiplied by share_Value1 here it is "Sum Value"
Next I need two columns that containe "Sum Value" divided by average_Value1 and they are "Receipt Value" and "Offer Value"
Then I need to multiply Sum_Value by Reciept_Value to get "Value1_for_receipt" and here is all going wrong.
Same story with another Reciept_Value*average_price it also returns not what I expect to see