Forum Discussion

admin11's avatar
admin11
Icon for Memorable Member rankMemorable 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
Icon for Impactful Individual rankImpactful Individual
5 years ago

hi admin11 

 

Can you share the pbix file..

 

Thanks & Regards,

Mohammed Adnan

  • V-lianl-msft's avatar
    V-lianl-msft
    Icon for Community Support rankCommunity 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
      Icon for Memorable Member rankMemorable 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

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

        Hi admin11 ,

         

        Do you want to display the sum of the most recent months in the fact table with a card?

        Try this measure:

        Measure = var min_ = CALCULATE(MAX(GL[Posting Date]),ALLSELECTED('Date'))
var ym = FORMAT(min_,"YYYY-MM")
return CALCULATE(GL[AMOUNT],FILTER(GL,GL[1_EXP]="EXP"),FILTER('Date','Date'[YrMth Sort]=ym))

         

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