Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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 |
---|---|
97 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
111 | |
96 | |
96 | |
67 | |
63 |