Combine two date columns in one column

[sainig546]

Hi,

I have two date column created date and updated date

now i want to create a single column of dates

where created date=updated date

is it possible?

[sainig546]

Thanks amit

[amitchandak · Accepted solution]

@sainig546 , New column

if([created date] = [updated date], [updated date], blank())

or are you looking for a solution where you want have common date table for 2 dates.

refer https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...