Dax | Calculate the date using the two different Table.

[Anonymous]

Hi ,

I have two column in Table A :Contract Line - Column: Contract Start Date and CREATED_TIMESTAMP  and

          One column in Table B: Date - Column: Date,

I need to caluclate the date like below if condition using Dax or new column in Table B.  Please guid me how to achive it.

Active Date = IF (

'Date'[Date] >= 'Contract Line'[Contract Start Date],

'Contract Line'[CREATED_TIMESTAMP],

IF (

'Contract Line'[CREATED_TIMESTAMP] < 'Contract Line'[Contract Start Date],

'Contract Line'[Contract Start Date] )

Thank you,

Ab

[Anonymous]

Thanks for response,

I am looking for Dax fomula. I am trying to add new column generate date which combines from two different table.

'FACT Contract Line' and BZ vw_DIM_DATE. I have joined the two table with 

'FACT Contract Line'[CREATED_TIMESTAMP] and BZ vw_DIM_DATE[Date]. I want below Dax to work, but is getting error. Is there any other Method or Correct DAX Formula you can suggest. 

Thank you,

Ab

[wdx223_Daniel]

@Anonymous  plase try RELATED(BZ vw_DIM_DATE[Date]) in calculated column if these two table have a one-many relationship

[amitchandak]

@Anonymous , Not very clear. But seem like very similar to HR usecase.

Please refer

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970

Video: https://www.youtube.com/watch?v=e6Y-l_JtCq4