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:
![](https://uploads-eu-west-1.insided.com/pigment-en/attachment/54884416-c7da-44bb-ae8d-720e8204a380.png)
Example:
![](https://uploads-eu-west-1.insided.com/pigment-en/attachment/c18ad083-44e3-4183-adb3-230d97074ae9.png)
Thanks in advance!
Best answer by Issam Moalla
View original