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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply

a measure to show the rebate required bases on tiered monthly revenue

hi guys,

 

im trying to create a measure that will show the rebate required to a customer based on the policy below

 

Monthly revenue, $ discount
FromToIncrement rate
$0$1,000$1,000  
1,0012,000999  
2,0013,000999 1.0%
3,0014,000999 1.5%
4,0015,000999 2.0%
5,0017,000999 2.5%
5,00112,5004,999 4.0%
12,50117,5004,999 5.0%
17,50122,5004,999 6.0%

 

Im sure its pretty simple but im new this, id like to be about to show this in a table if possible against each account we have.

 

Look foward to seeing your solutions!

1 ACCEPTED SOLUTION

Hi @Kieran_choudary,

 

You need to specify which rebate do you have when the revenue is less than 2000"

I don't find it in your formula and you can add another value ( zero or blank) for values not contain in all these intervals.

 

Thx

View solution in original post

7 REPLIES 7
TomMartens
Super User
Super User

Hey, it seems that the last lines of your sample data are a little flawed regarding the increment



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany
vanessafvg
Super User
Super User

@Kieran_choudary best thing to do is use a switch statement if i understand you correctly

 

 

ie.

 

rebate = switch(true(),

and (monthlyrevenue >= 0, monthlyrevenue <= 1000), 1,

and (monthlyrevenue > 1000, monthlyrevenue <= 2000), 1.5,

etc

 

)

 





If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!




ok im defiantly getting closer!

 

any idea why some give me the value i need and some say true/ false, i need the all as numbers to create the next measuereabte 3.PNGrebate 2.PNG

Hi @Kieran_choudary,

 

You need to specify which rebate do you have when the revenue is less than 2000"

I don't find it in your formula and you can add another value ( zero or blank) for values not contain in all these intervals.

 

Thx

Thank you!! you just saved me 5 hours a week!!

thanks for you help!!

 

But this is what it says

 

rebate.PNG

@Kieran_choudary

 

you have too many brackets

 

and ( condition1, condition2) 

 

not

 

and (condition1,(condition2)





If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!




Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

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