Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Automatically multiplying data based on individual row values

Hi All,   I'm pretty new to Power Bi and still getting to grips with DAX expressions and the like, hoping for some guidance on something that's got me pulling my hair out ATM!   Here is a s...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    6 years ago

    Hi,

    This is the kind of calculation you should be doing in a calculated column.  Assuming you have a column for Product, try this calculated column formula

    =IF(Data[SKU]="2163986-5",IF(Data[Product]="Sour Apple",Data[Qty]*5,Data[Qty]),Data[Qty])

    Hope this helps.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hey Anonymous,

 

Thank you, this is the level of complexity in DAX that complete elludes me at the moment.

 

I will try inputting this measure, I'm assuming I will need to replicate the formula for each individual SKU to get a complete number of product sold by SKU?

 

Also thanks for the book suggestion, I love the functionality of Power BI and really hope to master it as soon as I am able.

 

All the best,

Tom

Anonymous's avatar
Anonymous
Not applicable
6 years ago

You should only need this 1 measure. Basically what it does is take the number after - and multiply it by the quantity.

Im looking a little closer to to the structure of the data and it might get a little more complex when you take a look at 2148190-3 what would be the amount you want to multiply it by?