We can do same by using calculate in total YTD then what is real difference ? What ever we do in DatesYTD by using calculate we do that TotalYTD as well right ??
I have DATESYTD calculation and it is showing proper value in table format as per YEAR MONTH, but when I use same dax in column chart, only shows the YEAR in x asix. I want to shows same like your visualization. Please help me to solve this
Hello. I have tried using a FILTER() function to the 'filter' argument of the TOTALYTD and it worked. So with that approach, wouldn't it be the same output when using the Calculate and DatesYTD?
The "3/31" in the TOTALYTD function specifies the fiscal year-end date. This means that the function will calculate the year-to-date total based on a fiscal year that ends on March 31st, rather than the default calendar year-end of December 31st.
![ILLSLICK - KILLSHOT REMIX [FULL VERSION]](http://i.ytimg.com/vi/RIK8RrqIAzE/mqdefault.jpg)
Nice and easy explantion..Thanks...
Glad you liked it
We can do same by using calculate in total YTD then what is real difference ?
What ever we do in DatesYTD by using calculate we do that TotalYTD as well right ??
I have explained the key difference. watch the video again.
you cant use multiple filters that is the main difference
It's very helpful, thanks! ❤
Thanks, keep learning!
Thank you 🎉
thanks , keep learning
well Explained thanks
Glad it helped
I have DATESYTD calculation and it is showing proper value in table format as per YEAR MONTH, but when I use same dax in column chart, only shows the YEAR in x asix. I want to shows same like your visualization. Please help me to solve this
Used Year+Month combination in column chart that will work fine
Hello. I have tried using a FILTER() function to the 'filter' argument of the TOTALYTD and it worked. So with that approach, wouldn't it be the same output when using the Calculate and DatesYTD?
Yes
Why you are write "3/31"
Please let me know sir
Watch video again
The "3/31" in the TOTALYTD function specifies the fiscal year-end date. This means that the function will calculate the year-to-date total based on a fiscal year that ends on March 31st, rather than the default calendar year-end of December 31st.