Relative date YTD not working

Question

When I do the relative date it has to say 1/1/2020 to 9/11/2020(todays date)But it defaults to the max date available.Can you please let me know if it can default to today's date?&nbsp;&nbsp;

fowmy · Answer

Anonymous&nbsp;Relative filter does not have a YTD filter, Relative This year always takes the whole current year.If you need to set the dates for the current year till today, create a custom column in your date table like [date]&lt;= today().&nbsp;This will have TRUE / FALSE columns, you can assign it to the page filter to automatically filter dates till today.________________________If my answer was helpful, please consider Accept it as the solution to help the other members find itClick on the Thumbs-Up icon if you like this reply 🙂YouTube&nbsp; LinkedIn________________________If my answer was helpful, please consider Accept it as the solution to help the other members find itClick on the Thumbs-Up icon if you like this reply 🙂YouTube&nbsp; LinkedIn

anonymous · Answer

How can i get YTD in date ranges?

fowmy · Answer

Anonymous&nbsp;Please refer to this thread on how to achieve the samehttps://community.powerbi.com/t5/Desktop/Is-Today-Column/td-p/957057________________________If my answer was helpful, please consider Accept it as the solution to help the other members find itClick on the Thumbs-Up icon if you like this reply 🙂YouTube&nbsp; LinkedIn

amitchandak · Answer

Anonymous , In your date calendar you can have date type like this
&nbsp;
Date Type = SWITCH(TRUE(),'Date'[Date]=TODAY(),"Today",'Date'[Date]=TODAY()-1,"Yesterday",'Date'[Date]&amp;"")
&nbsp;
You can sort this on date. And use datesytd with date calendar
example
YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD('Date'[Date],"12/31"))Last YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD(dateadd('Date'[Date],-1,Year),"12/31"))This year Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD(ENDOFYEAR('Date'[Date]),"12/31"))Last year Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD(ENDOFYEAR(dateadd('Date'[Date],-1,Year)),"12/31"))Last to last YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD(dateadd('Date'[Date],-2,Year),"12/31"))Year behind Sales = CALCULATE(SUM(Sales[Sales Amount]),dateadd('Date'[Date],-1,Year))
&nbsp;
To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer : https://radacad.com/creating-calendar-table-in-power-bi-using-dax-functions https://www.archerpoint.com/blog/Posts/creating-date-table-power-bihttps://www.sqlbi.com/articles/creating-a-simple-date-table-in-dax/See if my webinar on Time Intelligence can help: https://community.powerbi.com/t5/Webinars-and-Video-Gallery/PowerBI-Time-Intelligence-Calendar-WTD-YTD-LYTD-Week-Over-Week/m-p/1051626#M184Appreciate your Kudos.

Forum Discussion

Relative date YTD not working

4 Replies

Related content

Find Most Recent Date Relative to another Date Column in Power Query

Relative Date Filter suddenly stopped working

Relative Date Filter Not Working?

Relative Date and Custom Date slicers conflicting

Relative Date filter, working with weeks.