Forum Discussion
Solved
Custom YTD
I want to create custom Year To date. I am currently using the query Calculate(Sum(value),DATEADD(Date,-1,Year)) and this calculation is -365 days. I want to give the start date as (Start of the d...
Calculate(Sum(value),DATESBETWEEN(Dates[Date],Date(Year(Today())-1,1,1),Today()-365))
Calculate(Sum(value),DATESBETWEEN(Dates[Date],Date(Year(Today())-1,1,1),Today()-365))
Thank you very much for your response, This is working great.