Forum Discussion

Tarek78's avatar
Tarek78
Icon for Helper I rankHelper I
2 years ago

Dax for Bonus Threshold

Hi All   We give our customers a bonus based on various conditions. Those conditions are different per customer but the same logic.    example:    customer 1: if revenue < 1M€, no bonus. Betwee...
Data model
DAX
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

That's a standard prorated pattern.  Why not a data model, indeed?

 

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

Tarek78's avatar
Tarek78
Icon for Helper I rankHelper I
2 years ago

Thanks for your reply. I agree, the easiest and my preferred option would be to create a data model where we will use excel files to compile all the different bonuses and thresholds. 

However I'm not sure how to build this.