Forum Discussion

admin11's avatar
admin11
Icon for Memorable Member rankMemorable Member
5 years ago
Solved

which YTD expression is better ?

Hi All   Below both expression work fine :-   _YTD_REV_ROBERT = var _max = today() return calculate(TOTALYTD([AMOUNT],'Date'[Date]),GL[1_REV] = "REV",filter('Date','Date'[Date]<=_max))   ...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    admin11 , ideally the first one should display data till today only.

    With TOTALYTD not need to calculate.

    Both functions are almost the same.

     

    I prefer to use calculate to I use DATESYTD more often

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

admin11 , ideally the first one should display data till today only.

With TOTALYTD not need to calculate.

Both functions are almost the same.

 

I prefer to use calculate to I use DATESYTD more often