Forum Discussion

admin11's avatar
admin11
Memorable Member
5 years ago

How to modify expression return Feb 2021 Amount ?

Hi All   I have below YTD expression working fine :-   _YTD EXP = CALCULATE(CALCULATE(GL[AMOUNT],DATESYTD('Date'[Date],"12/31")), GL[1_EXP] = "EXP")   Can some one help me to modify the above ...
Need Help
mohammedadnant's avatar
mohammedadnant
Impactful Individual
5 years ago

HI admin11 

Try this 2 formulas..

 

TOTALMTD(GL[AMOUNT], 'DATE'[DATE], ALL('DATE'[DATE]), GL[1_EXP] ="EXP")

 

TOTALYTD(GL[AMOUNT], 'DATE'[DATE], ALL('DATE'[DATE]), GL[1_EXP] ="EXP", "02/28")

 

Thanks & Regards,

Mohammed Adnan

admin11's avatar
admin11
Memorable Member
5 years ago

mohammedadnant 

 

Thank you for your sharing .

 

The first expression , i get error msg :-

 

Too many arguments were passed to the TOTALYTD function. The maximum argument count for the function is 4.

 

the second expression , i get error msg :-

 

Too many arguments were passed to the TOTALYTD function. The maximum argument count for the function is 4.

 

Paul Yeo