Forum Discussion
Solved
YTD calculation not working properly
Hi all, I am trying to make a very simple exercise with a verys imple model using the TOTALYTD DAX formula but there is something not working properly for me. I have created the following mea...
That was very helpful! So apparently all that I was missing to make my thing work is to add ".[Date]" to my formula. Tried it and worked like a charm. Thanks!
I think you have to use ALL function. just try it, i am not sure.
YTDSales = TOTALYTD(SUM(OrderDetail[Sales]), ALL(OrderHeader[OrderDate]))
If I answered your question, accept it as solution and give kudos!