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

AndreiK15's avatar
AndreiK15
Icon for Helper II rankHelper II
5 years ago

Hi,

 

Try the following:

 

CALCULATE(SUM(Table[ODC Expense],DATESYTD(Table[Month]))

 

 

 

It should work!

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

    Hey AndreiK15 ,

    Thanks for your reply. I tried this measure but still get the same error.
    I am trying to have a Table visual (image below) with ODC Expense and Resource direct cost by Project code. I can set a filter to this visual by using the month column in the filter pane and manually selecting the months until this month but I want to make it dynamic and just create a measure which returns just the YTD values for ODC expense and RDC. The card visual has the YTD ODC expense field and is broken and returns the following error. When I drop the YTD ODC Expense measure in the table visual it breaks too

     

     

    Looking forward to hearing from you. Thanks!