Forum Discussion

akkitek's avatar
akkitek
Icon for Helper III rankHelper III
5 years ago
Solved

TotalYTD function returning error

Hey All, I have a column with values and a column with dates (image below). I'm trying to create a simple measure calculating the YTD sum of the values. I tried the following measure:  ODC Expense...
Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi  akkitek ,

    You can try to change the formula to the following form:

    ODC Expense YTD =
CALCULATE(SUM('FACT_Fin_Data_by_Mo'[ODC Expense]),
FILTER(ALL('Calendar'),'Calendar'[Date]<=TODAY()&&'Calendar'[Date]>=DATE(YEAR(TODAY()),1,1)))

    Result：

     

    Best Regards,

    Liu Yang

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

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

Ashish_Mathur I didn't ask about my post, I asked about how your reply is different than mine?

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

How would i know that unless i read the contents in the link of your post?