Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Need to calculate ramp up time to achieve a fixed sales target. I have their start dates, just need to figure out how long it takes them from their start date to achieve that goal.
Salesperson A: 9 months
Salesperson B: 12 months
etc.
Seems simple, but I can't figure it out. Please help.
Please share some example/mock data to get a better proposed solution. Basically, you can get this with a measure in which you:
1. make a variable with the start date
2. make a variable that calculate the minimum date where the sales are above/equal to the target, using CALCULATE and FILTER
3. use DATEDIFF to get the time between 1 and 2
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
User | Count |
---|---|
79 | |
74 | |
62 | |
61 | |
45 |
User | Count |
---|---|
108 | |
98 | |
89 | |
82 | |
61 |