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

akkitek for time intelligence, it is a best practice to add a calendar dimension in your model, and you can follow my blog post here to add one and then use Date column from this dimension in TOTALYTD DAX function. 

 

✨ Follow us on LinkedIn

 

Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

 

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

 

 

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

Thank you for your reply and nice blog! I tried this, I created the calendar table using 'Calendarauto' function and joined the dates with the month column in my main table. And created a measure like, TotalYTD(SUM(odc_expense),Calendar[date]) but still get the same error.