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?
Go to Solution.
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:
MAX( 'Table'[Date1] )
> MAX( 'Table'[Date2] ),
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 AnswerHow to Get Your Question Answered Quickly - Give us a good and concise explanationHow 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.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
View solution in original post
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!
Try something like this:IF ( 'Table'[Renewed Contract Date] > 'Table'[Contract Date], "Late", "Anticipated" ).
Click here to read more about the October 2021 Release!
Explore the latest tools,training sessions,technical expertise, networking and more.
Mark your calendars and join us for our next Power BI Dev Camp!