join with start date with timestamp and end date with timestamp

[Anonymous]

Hi,

How make  a create this as a single column start date with timestamp and end date with timestamp and i want to join that datetimestamo with another table

[Greg_Deckler]

I am not 100% certain what you are trying to achieve. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

But, if you are trying to get 1 column with all of the values from both of the columns you can use SELECTVALUES and UNION like:

Table = 

  DISTINCT(

    UNION(

      SELECTCOLUMNS('Table',"Column",[DateAdd]),

      SELECTCOLUMNS('Table',"Column",[DateSub),
    )

  )

Something like that.

[amitchandak · Accepted solution]

Follow this. You can force join in measure

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