Forum Discussion

ovetteabejuela's avatar
ovetteabejuela
Icon for Impactful Individual rankImpactful Individual
9 years ago
Solved

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 ...
Need Help
  • Phil_Seamark's avatar
    Phil_Seamark
    9 years ago

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

  • v-sihou-msft's avatar
    v-sihou-msft
    9 years ago

    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.

     

     

     

    Regards,

Harpreet1405_12's avatar
Harpreet1405_12
Icon for Helper III rankHelper III
3 years ago

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