Skip to main content
Solved

Add prior month result

  • August 1, 2023
  • 1 reply
  • 480 views
Y
Master Author
Forum|alt.badge.img+8

Hi Pigment team! Can you please help modifying this formula to be as following explanation?

 

Current formula:

IF(S03_IsActuals, 
   'DH_Data_PL EBITDA Actuals'[FILTER: 'PL GLs'."60001"],
   'TT_Base Salary USD'[REMOVE SUM: Country][BY: 'PL GLs'."60001"]
)

I would like to add “EE_Salary_USD (Actual - Forecast)” metric in the “false” section, but with prior month result. I started like below, but I am not sure what to put in the highlighted section below: 

Example:

 

Thanks in advance!

Best answer by Issam Moalla

Hi @Yaejis ,

In order to reference the prior month from another metric you can update your formula as follows:
 

IF(S03_IsActuals, 
   'DH_Data_PL EBITDA Actuals'[FILTER: 'PL GLs'."60001"],
   'TT_Base Salary USD'[REMOVE SUM: Country][BY: 'PL GLs'."60001"] + EE_Salary_USD (Actual - Forecast)[SELECT: Month - 1]
)

Let me know if the problem is solved.

for more reading around the usage of this you can check the following article:
 


Best,
Issam

    KarlW

    1 reply

    Issam Moalla
    Employee
    Forum|alt.badge.img+11
    • Issam MoallaEmployee
    • Employee
    • Answer
    • August 3, 2023

    Hi @Yaejis ,

    In order to reference the prior month from another metric you can update your formula as follows:
     

    IF(S03_IsActuals, 
       'DH_Data_PL EBITDA Actuals'[FILTER: 'PL GLs'."60001"],
       'TT_Base Salary USD'[REMOVE SUM: Country][BY: 'PL GLs'."60001"] + EE_Salary_USD (Actual - Forecast)[SELECT: Month - 1]
    )

    Let me know if the problem is solved.

    for more reading around the usage of this you can check the following article:
     


    Best,
    Issam

    KarlW
    Benji

    Ask your question here!

    Terms & ConditionsCookie settingsAccessibility statement