Forum Discussion

BarryM's avatar
BarryM
Helper II
4 years ago
Solved

Trying to insert data from multiple tables into another existing table based on column names

I have a PBIX file with 9 different tables. 1 of the tables is essentially a history table which contains all the data from the start of this project. The other 8 tables contain data which is updated...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi BarryM 

    Power BI doesn't support to dynamicly insert values into Existing columns.

    I think you can try to add calculated columns into your history table. I see you create relationship between your tables, you can try related function, userelationship functions ,or filter in your code.

    Or you can try merge function in Power Query.

    For reference: 

    Combine queries

    Both calcualted column or Combine queries will show the latest value from other tables.

     

    Best Regards,
    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi BarryM 

Power BI doesn't support to dynamicly insert values into Existing columns.

I think you can try to add calculated columns into your history table. I see you create relationship between your tables, you can try related function, userelationship functions ,or filter in your code.

Or you can try merge function in Power Query.

For reference: 

Combine queries

Both calcualted column or Combine queries will show the latest value from other tables.

 

Best Regards,
Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.