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
Can you post the sample date and expected table output for easy understanding?
Thanks
Raj
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
