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.
Very nicely explained. Thank you very much. 🙏
Thanks keep learning share this channel with friends and colleagues
Nice and easy explantion..Thanks...
Glad you liked it
It's very helpful, thanks! ❤
Thanks, keep learning!
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
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
Thank you 🎉
thanks , keep learning
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
well Explained thanks
Glad it helped
Hi nags, today date is 9-1-2025. As of now you can use two filters in TOTALYTD function. Please check.
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.