Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Frequent Visitor

Automatic relative date filter for YTD card

Hi there,


I have a YTD card in my report with a delta value card next to it.

Bildschirm­foto 2023-02-02 um 15.44.37.png

The delta card has a relative date filter which is set to "in the last 1 calendar month" and shows the correct data. We update the dashboard on a monthly basis and I would like to not have to adjust the date filter each time. (from "1 calender month" to "2 calender months" and so on)

Is there any way to automate this? If I set the filter to "this year" the LYTD function will give out the complete data of last year and the delta will therefore not work correctly.


Here are my functions:

ImprYTD = TOTALYTD([Total Impressions],LU_DATES[Date])
ImprDelta = DIVIDE([ImprYTD], [ImprLYTD]) -1


I can provide more details on the underlying data if needed.


Thanks in advance


Frequent Visitor

Hi @amitchandak 


I have added new measures based on the functions you provided and also created a new Delta measure from them. However, the Last YTD Measure still shows me the value of the full year (87 million). I tried using the relative date filter on it using "in this year" but it didn't change the outcome. 

Do you think the error could lie in the date table? I took a screenshot of it, hoping this gives some insight.

Bildschirm­foto 2023-02-03 um 09.55.51.png


Bildschirm­foto 2023-02-03 um 09.52.18.png



Super User
Super User

@lstenz , Make sure you are using date table, in measure, slicer and visual and measure like


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"))


Why Time Intelligence Fails - Powerbi 5 Savior Steps for TI :


Time Intelligence, Part of learn Power BI
Time Intelligence, DATESMTD, DATESQTD, DATESYTD, Week On Week, Week Till Date, Custom Period on Period,
Custom Period till date:

Helpful resources

Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City


Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.