Custom Column IF statement

[mdp1202]

I can't seem to figure this out, yet it feels so elementary. I have a table in my BI Power Query, and in one column titled "Type" the text values will be one of 3 items: Demand, Supply, or On Hand. I have another column that is a whole number titled "Quantity". I would like to create 3 custom columns, one each for Demand, Supply, and On Hand, where if "Type" = "Demand", then "Quantity", else 0, and so on for the other two. I have this in Excel, just can't figure out the DAX to do it in BI. Sample from Excel below, again I am trying to create conditional columns such as the ones highlighted green in BI. Thanks for your help!

[Vijay_A_Verma · Accepted solution]

Use following formulas in DAX for custom columns

Demand = IF([Type]="Demand",[Quantity],0) 
Supply = IF([Type]="Supply",[Quantity],0)
On Hand = IF([Type]="On Hand",[Quantity],0)