Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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 Ha...
Need Help
Show and Tell
Tutorial Requests
  • Hariharan_R's avatar
    Hariharan_R
    4 years ago

    Hi Anonymous 

    Refer the attached PBIX file.

    2021 YTD = CALCULATE(TOTALYTD(SUM('Table'[Qty]),'Date'[Date]),'Table'[Year]=2021)
     

    Download

    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


Hariharan_R's avatar
Hariharan_R
Icon for Solution Sage rankSolution Sage
4 years ago

Hi Anonymous 

Refer the attached PBIX file.

2021 YTD = CALCULATE(TOTALYTD(SUM('Table'[Qty]),'Date'[Date]),'Table'[Year]=2021)
 

Download

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