Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to Solution.
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")
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")
Did work thank you!!
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
122 | |
101 | |
71 | |
61 |