Forum Discussion
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/2019 to second Quarter(now Second Quarter) of 2019.
4 Replies
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 🙂Anonymous well maybe you have some missing stuff in your model.
impossible to know without getting more info about it.
Go over this full explanation of the time intelligence pattern anc check to see if you can find the somking gun:
https://www.daxpatterns.com/standard-time-related-calculations/
Let me know the status
