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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

True/False in a new field after comparing two dates

Hi all, thank you in advance for your assistance.

 

I have one dataset bringing two dates: Due Date and Done Date. I need to compare the two dates. If the job was done on the same month/year of due date is true, if not False. As new column.

Done date     Due date      True/False

Jun.09.2013   Jun.12.2013  True

Jun.12.2013   Jul.15.2013    False

 

Regards

Jose Milhazes

2 ACCEPTED SOLUTIONS
RolandsP
Resolver IV
Resolver IV

One way how to get this would be:

 

True/False = IF ( CONCATENATE(MONTH(Sheet1[Due date]), YEAR(Sheet1[Due date])) = CONCATENATE(MONTH(Sheet1[Done date]), YEAR(Sheet1[Due date])), "True", "False")

View solution in original post

Anonymous
Not applicable

Did work thank you!!

View solution in original post

2 REPLIES 2
RolandsP
Resolver IV
Resolver IV

One way how to get this would be:

 

True/False = IF ( CONCATENATE(MONTH(Sheet1[Due date]), YEAR(Sheet1[Due date])) = CONCATENATE(MONTH(Sheet1[Done date]), YEAR(Sheet1[Due date])), "True", "False")

Anonymous
Not applicable

Did work thank you!!

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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