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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
MarkMellink
Frequent Visitor

DateAdd for measures

Hi,

 

I have a measure, which is a DateTime. I'm trying to subtract Years/Months/Days from this measure. But can't seem to find an easy way to do this.

 

Basically, I'm looking for a DateAdd function, but that accepts a single date instead of a column of date.

 

Example:

 

Measure: [FirstDate] = MIN(Table[Date])

FirstDate20DaysAdded = DateAdd([Firstdate],20,Days)

3 REPLIES 3
Paz2019
Regular Visitor

Hi! Could you resolve it? I want to do the same (Dateadd for a measure and not to a column)

I recommend that you put the exercise you want to find to be able to understand the dateadd what it does is Returns a table that contains a column of dates, shifted either forward or backward in time by the specified number of intervals from the dates in the current context.

Alright. What I eventually want to do is get the difference between that measure, and the current day. But in a text format, for example:

* 2 year(s), 3 month(s), 22 day(s).

* 3 month(s), 22 day(s).

* 22 day(s)

 

I've broken this up into several measures:

 

[FirstDate] = MIN(Table[Date])

[YearValue] = DATEDIFF([FirstDate],TODAY(),YEAR)

[YearValueText] = IF([YearValue] >= 1, CONCAT([YearValue]," year(s)"), "")

[MonthValue] = DATEDIFF(DATEADD([FirstDate],[YearValue],YEAR),TODAY(),MONTH)

This is where I need that DATEADD for a measure.

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

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