Forum Discussion
Multiple IF checks in Custom Column based on ID
Hey all, so I'm trying to create a custom column that will produce percentage rates depending on the total spend, but different service numbers have different rates. For example.
(if([RadarService] = 5) then if[TotalCost] < 5000 then .60 else if[TotalCost] > 5000 then .56 else null
Then in the same custom column, I would want it to do the same check but for radarservice2 for example.
(if([RadarService] = 2) then if[TotalCost] < 5000 then .16 else if[TotalCost] > 5000 then .15 else null.
Any question let me know, I'm trying to wrap my head around PowerBi and it's queries
2 Replies
I'm struggling to understand what your question is? Your code below looks pretty close to what you need to put in. Have you tried using the "Add Column" option in the Edit Queries window and used code similar to what you have shown below?
Was there something specific that didn't work with your approriate? Were you just unsure how to do nested ifs with Power Query?
If that last question was your actual question, then your assumption was correct based on the structure of the code you wrote.