Hi, I'm somewhat of a novice and trying to calcuate a margin that varies based on the sum.
The margin is 30% up to $12,000
When revenues exceed $12,000, the margin is 30% on the first $12,000 and then 20% on everything after $12K
Is there a way to create an active calculation for this in Power BI?
I'd like to calculate and show the margin amount over time. In the example data below, I have week-by-week data that goes back to before the 12K threshold and upcoming weeks that will exceed the 12K threshold. How can I create an active calculation so that I can visualize the week-by-week margin despite the variable rate?