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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
akkitek
Helper III
Helper III

Calculating Costs by referencing bonus percentage from another table

Hi everyone,
I am trying to write a couple of dax calcuations to calculate costs based on the bonus percentages from another table. I have two tables which look like this:
Rates Table:

akkitek_0-1658168546588.png

 

 

Bonus Table:

akkitek_2-1658169750680.png

 

 

I need to create a column to calculate the Bonus for the dates in the rates table. So for a specific date, the bonus is the bonus percentage(for that month) of the rate(on that date). Then bonus + rate = cost. 

These 2 tables have a many to many relationship. 

 

The desired result would look something like this  

akkitek_3-1658170057862.png

Here's the link to the test file: https://drive.google.com/file/d/1tHzZSR6W0ArDc5FOoXDx_S1UhCtdKQCW/view?usp=sharing
Any help is appreciated. Thank you!

1 ACCEPTED SOLUTION
SpartaBI
Community Champion
Community Champion

@akkitek is this what you meant?:
Calculating Costs by referencing bonus percentage from another table 2022-07-18.pbix

Pay attention I had to changed the data type of EMP ID to whole number (it was text) to work with the ID number in the Bonus table.



2022-05-19 17_30_22-Re_ Need help on DAX function with measure vs colu... - Microsoft Power BI Commu.png


Full-Logo11.png

SpartaBI_3-1652115470761.png   SpartaBI_1-1652115142093.png   SpartaBI_2-1652115154505.png

Showcase Report – Contoso By SpartaBI

View solution in original post

3 REPLIES 3
SpartaBI
Community Champion
Community Champion

@akkitek is this what you meant?:
Calculating Costs by referencing bonus percentage from another table 2022-07-18.pbix

Pay attention I had to changed the data type of EMP ID to whole number (it was text) to work with the ID number in the Bonus table.



2022-05-19 17_30_22-Re_ Need help on DAX function with measure vs colu... - Microsoft Power BI Commu.png


Full-Logo11.png

SpartaBI_3-1652115470761.png   SpartaBI_1-1652115142093.png   SpartaBI_2-1652115154505.png

Showcase Report – Contoso By SpartaBI

Thank you @SpartaBI ! This worked well!

SpartaBI
Community Champion
Community Champion

@akkitek my pleasure 🙂
Check out my showcase report - got some high level stuff there. Sure you will find there a lot of cool ideas. 
https://community.powerbi.com/t5/Data-Stories-Gallery/SpartaBI-Feat-Contoso-100K/td-p/2449543
Give it a thumbs up over there if you liked it 🙂

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Feb2025 NL Carousel

Fabric Community Update - February 2025

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