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
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

mohammedadnant's avatar
mohammedadnant
Impactful Individual
5 years ago

hi admin11 

 

Can you share the pbix file..

 

Thanks & Regards,

Mohammed Adnan

    • V-lianl-msft's avatar
      V-lianl-msft
      Community Support
      5 years ago

      Hi admin11 ,

       

      Your formula is used to calculate YTD. If you want to calculate the value of February, it is recommended that you apply filters to [amount].

       

       

      Best Regards,
      Liang
      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

      • admin11's avatar
        admin11
        Memorable Member
        5 years ago

        V-lianl-msft 

        Thank you for sharing.

        The reasons i need it with out using filter panel is because , i need it dynamic change every month with me change the filter panel setting. 

         

        Paul