Forum Discussion

MarieBell's avatar
MarieBell
New Member
3 years ago

Measures for incentive calculation based on margin after allocating annual fixed costs

I am a new Power BI user and trying to translate Excel spreadsheets into Power BI reports. We have sales, purchase and margin data for a salesperson that we use to calculate an monthly incentive amo...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

MarieBell , Try if these approaches can help

powerbi Distributing/Allocating the Yearly Target(Convert to Daily Target): https://community.powerbi.com/t5/Community-Blog/Distributing-Allocating-the-Yearly-Target-Convert-to-Daily/ba-p/1463290

 

PowerBI Distributing/Allocating the Yearly Target(Convert to Daily Target): Measure ( Daily/YTD): Magic of CLOSINGBALANCEYEAR With TOTALYTD/DATESYTD: https://community.powerbi.com/t5/Community-Blog/Power-BI-Distributing-Allocating-the-Yearly-Target-Convert-to/ba-p/1476400