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 

    i Just finish watching the youtube.

    I try to change the Y to M :-

     

    _MTD EXP = CALCULATE(CALCULATE(GL[AMOUNT],DATESMTD('Date'[Date],"12/31")), GL[1_EXP] = "EXP")
     
    I get error msg :-

     

    • 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