Forum Discussion
Extrapolate/Fill or something?
Hi Jamez_P
You can refer to the following ways
1.Use merge queries in power query, find the same column among the tables, e.g the [employeeid] column in cost table and [employeeid] column in booking table, then expand it. you can refer to the following link.
Merge queries overview - Power Query | Microsoft Learn
2.If you have the relationship among tables, you can use calculate() function and related() function to find the related value from another table.
RELATED function (DAX) - DAX | Microsoft Learn
If the following above cannot meet your requirement, can you provide some sample data of the tables and the output picture you want?
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Jamez_P
You can refer to the following ways
1.Use merge queries in power query, find the same column among the tables, e.g the [employeeid] column in cost table and [employeeid] column in booking table, then expand it. you can refer to the following link.
Merge queries overview - Power Query | Microsoft Learn
2.If you have the relationship among tables, you can use calculate() function and related() function to find the related value from another table.
RELATED function (DAX) - DAX | Microsoft Learn
If the following above cannot meet your requirement, can you provide some sample data of the tables and the output picture you want?
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.