topic Dax | Calculate the date using the two different Table. in DAX Commands and Tips

Dax | Calculate the date using the two different Table.

Anonymous — Fri, 13 Nov 2020 18:55:33 GMT

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,

Re: Dax | Calculate the date using the two different Table.

amitchandak — Sat, 14 Nov 2020 02:09:07 GMT

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

Re: Dax | Calculate the date using the two different Table.

Anonymous — Tue, 17 Nov 2020 00:14:36 GMT

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,

Re: Dax | Calculate the date using the two different Table.

wdx223_Daniel — Tue, 17 Nov 2020 00:48:21 GMT

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