Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

YTD DAX

I am looking for a time intelligence Query which will return the data from beginning of selected  year to current quarter of that year. So basically for 2019 year it should give me data from 01/01...
Need Help
SpartaBI's avatar
SpartaBI
Icon for Community Champion rankCommunity Champion
4 years ago

Anonymous 

MEASURE Sales[Sales YTD] =
        CALCULATE (
            [Sales Amount],
            DATESYTD ( 'Date'[Date] )
        )


https://dax.guide/datesytd/
Check also the short video there.


In case it answered your question please mark this as a solution for community visibility. Appreciate Your Kudos 🙂