Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Thanks for your reply,

 

I was pretty mentally drained yesterday so get how I was hard to understand.

 

I actually just got back into work and solved the issue! It's amazing what a good sleep can do. 🙂

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

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.

Anonymous
Not applicable

Thanks for your reply,

 

I was pretty mentally drained yesterday so get how I was hard to understand.

 

I actually just got back into work and solved the issue! It's amazing what a good sleep can do. 🙂

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.