Solved

Add prior month result

  • 2 August 2023
  • 1 reply
  • 147 views

Userlevel 3
Badge +6
  • Newly Minted Pigmenteer
  • 21 replies

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!

icon

Best answer by Issam Moalla 3 August 2023, 11:53

View original

1 reply

Userlevel 5
Badge +9

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

Reply