Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all,
Apologies beforehand if this question has been answered earlier.
I have a dataset of cleared checklists (CLs) spanning from 2015 until now, and I want to display the actual RT and the actual + forecast RT. The latter is based on a series generated though the what if parameter, where I can adjust the number of CLs to see at what date the total number of CLs will be reached (around 50'000). The RT for just the actuals works fine, the problem arises when I try to combine it with the forecast RT thus I guess the problem lies with var = RT_Forecast. Also, I don't want the RT to reset per year/month/week, yet I want to display the data per week.
Moreover, the "Checklists per week" gets multiplied by 7 in the RT_forecast column, which I assume is due to the weekly aggregativ, though I didn't have this issue in an earlier try where I narroved the dataset to only weeks in 2021.
Below are the calculations I've used so far, any help for coding or structure would be much appreciated!
Best regards,
Marte
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
58 | |
50 | |
44 | |
19 | |
19 |