cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

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

Accepted Solutions
Highlighted
Frequent Visitor

Re: Multiple IF checks in Custom Column based on ID

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
Highlighted
Community Champion
Community Champion

Re: Multiple IF checks in Custom Column based on ID

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.

Highlighted
Frequent Visitor

Re: Multiple IF checks in Custom Column based on ID

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

Helpful resources

Announcements
Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Galleries

Galleries

Looking for inspiration on how to present your data? Need instructional videos? Check out our Galleries!

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors