To add new column, by comparing date fields from 2 tables

[vennajx]

Hello,

I have just started with Power BI, I'm not sure if this is a lame question to ask.

I have start_date in Table A and Approval_date in Table B.I want to compare these 2 date columns and create a new column say 'Flag'.If start _date is greater than approval_date then'1' else'0'.  I don't have direct relationship between the tables

@Greg_Deckler

[Anonymous]

No relationship--that's pretty tough to work with, but if you know that the dates between tables are on the same row, then you could try add a step like:

= List.Zip({#"Table A"[Start_Date], #"Table_B"[End_Date]})

Then you can extract the list values (as opposed to expanding to new rows) and do the row by row math.

--Nate

[vennajx]

@Anonymous I will try to get the relationship from the source team.Lets think we have key(PK) how can we compare.

[v-kelly-msft · Accepted solution]

Hi  @vennajx ,

If there is a primary key,you could use below method:

Create a column as below:

approval date = LOOKUPVALUE('Table B'[Approval_date],'Table B'[Index],'Table'[Index],blank())

And you will see:

Then you create another column to compare the two dates.

For the related .pbix file,pls see attached.

Best Regards,
Kelly

Did I answer your question? Mark my raeply as a solution!