Forum Discussion
DAX- year to date
Hello all,
Please help me in calculating YTD-2021 and YTD-2022 starting From JAN-DEC, and the result should be this.
please find attached images.
Thank You.
RaptorFox Tahreem24 Hariharan_R
Hi Anonymous
Refer the attached PBIX file.
2021 YTD = CALCULATE(TOTALYTD(SUM('Table'[Qty]),'Date'[Date]),'Table'[Year]=2021)Thanks
Hari
Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.
My Blog :: YouTube Channel :: My Linkedin
1 Reply
- Hariharan_R
Solution Sage
Hi Anonymous
Refer the attached PBIX file.
2021 YTD = CALCULATE(TOTALYTD(SUM('Table'[Qty]),'Date'[Date]),'Table'[Year]=2021)Thanks
Hari
Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.
My Blog :: YouTube Channel :: My Linkedin