Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi Community!
I would like to know how I can do this properly, the image below should show what my goal is:
Basically I dont want the target to end up to the sum of daily targets. Since this is a Rate target the dailies should be the same as the monthly target not the accumulated.
Or say whenever I choose a date range, the taget would not aggregate to the filtered days.
Here's the data that I used.
Sales Count | Work Hours (mins) |
94 | 428.1326408 |
73 | 350.6616239 |
80 | 357.1916753 |
86 | 423.9083607 |
86 | 282.6110697 |
76 | 335.1554057 |
72 | 451.1635545 |
51 | 405.49636 |
52 | 320.2297197 |
55 | 418.636617 |
56 | 363.1810663 |
55 | 370.9766479 |
725 | 3773.187027 |
Solved! Go to Solution.
Could you set the default sumarisation on the field to me something other than SUM (eg, MAX, MIN, AVERAGE) ?
As @Phil_Seamark said, to have the target "fixed" on all level, you just need to change the aggregation type for this field in either visual level or Modeling.
Regards,
Hello,
I need your help to set the targets for the upcoming months (Oct 2022- SEPT 2023) BASED on the historical data, I have the historical data from 2019 to 2022, so we go like Oct 2020-Sept 2021, Oct 2021-Sept 2022, Oct 2022-Sept 2023(I want to set the targets for these months) for 80 different programs or categories.
Is There any formula or any Dax function available.
I will highly appreciate the response.
Thank you
As @Phil_Seamark said, to have the target "fixed" on all level, you just need to change the aggregation type for this field in either visual level or Modeling.
Regards,
Could you set the default sumarisation on the field to me something other than SUM (eg, MAX, MIN, AVERAGE) ?
User | Count |
---|---|
103 | |
88 | |
78 | |
71 | |
69 |
User | Count |
---|---|
113 | |
99 | |
97 | |
72 | |
68 |