Forum Discussion

SSJ011's avatar
SSJ011
Frequent Visitor
5 years ago

Create Calculated column to get the correct date

Hi,    Want to get the correct date from the completion date and Time with one condition.   if the date & time is before 6:30 AM in the Completed column then the calculated column should take yes...
camargos88's avatar
camargos88
Icon for Community Champion rankCommunity Champion
5 years ago

SSJ011 ,

 

Try this measure:

 

Column = 
    IF(
        TIME(HOUR('Table'[Date]), MINUTE([Date]), SECOND([Date])) < TIME(6, 30, 00),
        DATEVALUE([Date] - 1),
        DATEVALUE([Date])
    )