Forum Discussion
Solved
Power Query : add column getting value from another one in an another table not related
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 ...
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
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
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
Hi Dale
That's wonderful, exactly what I needed :)
A great lesson learned today !
Best regards
Marc
v-jiascu-msft , Kindly explain how I can easly do it in Dax
