cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
fabiolamelo
Helper II
Helper II

Compare 2 Dates - IF Condition - HELP

Hi everyone,

 

I`m working on one project that I need to compare two columns date, which are:

 

Contract Date | Renewed Contract  Date 

27/01/2021    |        26/01/2021                  

27/01/2021    |        28/01/2021                  

 

If "Renewed Contract Date " is bigger than "Contract Date" inform "Late" if not "Anticipated".For example"

Contract Date | Renewed Contract  Date | 

27/01/2021    |        26/01/2021               | "Anticipated"

27/01/2021    |        28/01/2021               | "Late"

 

My idea is using the IF condition but I didn't find an away to compare two dates using this condition, can you please 

Can you please help me with it?

Thanks

1 ACCEPTED SOLUTION
edhans
Super User
Super User

If you want a calculated column @fabiolamelo then the solution by @danextian is what you need. If you want to do this in Power Query, you would use this:

= if [Date1] > [Date2] then "Late" else "Anticipated"

If you need this in a measure, you will need to provide a bit more details with some data so we can help, but one fast way to try this is to use this measure:

Status =
IF(
    MAX( 'Table'[Date1] )
        > MAX( 'Table'[Date2] ),
    "Late",
    "Anticipated"
)

But that is a total stab in the dark as I don't know your expected output - not late/anticipated - but how you want to express it in a visual.

How to get good help fast. Help us help you.

How To Ask A Technical Question If you Really Want An Answer

How to Get Your Question Answered Quickly - Give us a good and concise explanation
How to provide sample data in the Power BI Forum - Provide data in a table format per the link, or share an Excel/CSV file via OneDrive, Dropbox, etc.. Provide expected output using a screenshot of Excel or other image. Do not provide a screenshot of the source data. I cannot paste an image into Power BI tables.



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting

View solution in original post

3 REPLIES 3
edhans
Super User
Super User

If you want a calculated column @fabiolamelo then the solution by @danextian is what you need. If you want to do this in Power Query, you would use this:

= if [Date1] > [Date2] then "Late" else "Anticipated"

If you need this in a measure, you will need to provide a bit more details with some data so we can help, but one fast way to try this is to use this measure:

Status =
IF(
    MAX( 'Table'[Date1] )
        > MAX( 'Table'[Date2] ),
    "Late",
    "Anticipated"
)

But that is a total stab in the dark as I don't know your expected output - not late/anticipated - but how you want to express it in a visual.

How to get good help fast. Help us help you.

How To Ask A Technical Question If you Really Want An Answer

How to Get Your Question Answered Quickly - Give us a good and concise explanation
How to provide sample data in the Power BI Forum - Provide data in a table format per the link, or share an Excel/CSV file via OneDrive, Dropbox, etc.. Provide expected output using a screenshot of Excel or other image. Do not provide a screenshot of the source data. I cannot paste an image into Power BI tables.



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting

View solution in original post

@edhans 

I didn't know that using MAX the IF condition for this case will works 🙂 Thank you so much for your help, I`m using the measure with MAX as you suggest and it was perfect 🙂 God bless you!

danextian
Community Champion
Community Champion

Try something like this:
IF ( 'Table'[Renewed Contract Date] > 'Table'[Contract Date],  "Late",  "Anticipated"  ).

Did I answer your question? Mark my post as a solution!
"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
www.linkedin.com/in/danebelarminocpa

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.