difference date

[snifer]

my problem is that  I've two column

column 1 and column 2

they are date dd/mm/yyyy

I need to say that the row in column 1 are in a month before than the row in  column 2 ( could be 2 or more month of difference) ture false

I need to find a way to make give result so in 12/2017 is before than 01/2018

[Anonymous]

Regarding for "one month before", are you saying the date in column 2 should be at least 30 days older than the one in column 1? If this is the case, you can refer to the following DAX to get the rough result.

MoreThan1M = IF(DATEDIFF(TimeDiff[Column1],TimeDiff[Column2],DAY)>=30&&DATEDIFF(TimeDiff[Column1],TimeDiff[Column2],MONTH)>=1,TRUE())

[snifer]

for example in case of 29 march and 1 april, this is a different month, it will work rules of more than 30 days?

[Anonymous · Accepted solution]

If you are not care about the time interval between column1 and column2, and just want to mark two days from different months, you can use the following DAX.

Column = IF(DATEDIFF(MIN(TimeDiff[Column1],TimeDiff[Column2]),MAX(TimeDiff[Column1],TimeDiff[Column2]),MONTH)>=1,TRUE())

MIN and MAX function is just used for in case you have any date in Column 1 is early than the corresponding one in Column 2.

[v-yulgu-msft]

Hi @snifer,

Do you want to check whether the date in column1 is one month before that in column2? If yes, return true, otherwise return false.

You can add a calculated column like this:

check difference = IF(DATEDIFF(Table1[Column1],Table1[Column2],MONTH)=1,TRUE(),FALSE())

Best regards,

Yuliana Gu