Forum Discussion

Helper I

8 years ago

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 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

v-jiascu-msft
8 years ago
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

5 Replies

Anonymous
Not applicable
8 years ago
Can you post the sample date and expected table output for easy understanding?

Thanks
Raj
- marcp
  Helper I
  8 years ago
  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
    Microsoft Employee
    8 years ago
    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