Forum Discussion

marcp's avatar
marcp
Icon for Helper I rankHelper 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 ...
Need Help
  • v-jiascu-msft's avatar
    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}

    Power_Query

     

    Best Regards,

    Dale

v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft 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}

Power_Query

 

Best Regards,

Dale

GeffMburu's avatar
GeffMburu
Frequent Visitor
5 years ago

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