YTD DAX

[Anonymous]

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. 

[CNENFRNL · Accepted solution]

[Anonymous]

I already used it but somehow its not giving the right values

[SpartaBI]

@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

[SpartaBI]

@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 🙂