Forum Discussion
MarieBell
3 years agoNew Member
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...
MarieBell
3 years agoNew Member
Sorry for the delay, I've been offline for 4 weeks. These links both relate to allocating by the day so it will vary depending on the number of days in the month. My figures need to remain static for each month irrelevant on the number of days in it