Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
ovetteabejuela
Impactful Individual
Impactful Individual

Rates: Daily Target is Monthly Target (Target change Monthly)

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.

 

 

 

Monthly Target is Daily Target.PNG

 

Here's the data that I used.

Sales CountWork Hours (mins)
94428.1326408
73350.6616239
80357.1916753
86423.9083607
86282.6110697
76335.1554057
72451.1635545
51405.49636
52320.2297197
55418.636617
56363.1810663
55370.9766479
7253773.187027
2 ACCEPTED SOLUTIONS
Phil_Seamark
Employee
Employee

Could you set the default sumarisation on the field to me something other than SUM (eg, MAX, MIN, AVERAGE) ?


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

View solution in original post

v-sihou-msft
Employee
Employee

@ovetteabejuela

 

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.

 

123.PNG

 

234.PNG

 

Regards,

View solution in original post

3 REPLIES 3
Harpreet1405_12
Helper II
Helper II

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

v-sihou-msft
Employee
Employee

@ovetteabejuela

 

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.

 

123.PNG

 

234.PNG

 

Regards,

Phil_Seamark
Employee
Employee

Could you set the default sumarisation on the field to me something other than SUM (eg, MAX, MIN, AVERAGE) ?


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.