Power Query : add column getting value from another one in an another table not related

[marcp]

Hi all

I have a table A with one column and one row containing one only value

This value is obtained by a sql query (so it's dynamic one)

I have a second table B. I want to add a new column in B which will contains the same value from each row. This value is the one in table A.

There is no relation between A and B, so I can't make a join in power query.

I guess there is a simple way to do this with the M language but I'm stuck

Thank you for your help

Regards

Marc

[Anonymous]

Can you post the sample date and expected table output for easy understanding?

Thanks

Raj

[marcp]

Hi here are an example

To start, I have this

Table A

DateMax

14/05/2018

Table B
Reference	Date
X	05/01/2017
Y	01/04/2018
Z	15/01/2016

I need to add the value of DateMax in Table A for each row of Table B like this

Table B
Reference	Date	DateMax
X	05/01/2017	14/05/2018
Y	01/04/2018	14/05/2018
Z	15/01/2016	14/05/2018

The ultimate goal is to compute the number of days between the two dates (I know how to do this last part) :

Table B
Reference	Date	DateMax	Days
X	05/01/2017	14/05/2018	495
Y	01/04/2018	14/05/2018	44
Z	15/01/2016	14/05/2018	851

Thank you for your help

Regards

Marc

[v-jiascu-msft · Accepted solution]

Hi Marc,

You can do it easily with DAX. If you want the Power Query solution, please refer to the snapshot below.

TableA[DateMax]{0}

Best Regards,

Dale

[GeffMburu]

@v-jiascu-msft , Kindly explain how I can easly do it in Dax

[marcp]

Hi Dale

That's wonderful, exactly what I needed 🙂

A great lesson learned today !

Best regards

Marc