Forum Discussion
Multiple date columns in different tables
So you need to create a proper Calendar (Date) table and connect your Hours,Expenses,Invoices tables to it via Date field.
Here is an example how your model will look like:
Matrix:
Date from Calendar table in columns, Project from Project table, Hours amt from Hours table, Expenses amt from Expenses table.
If this post helps, then please consider Accept it as the solution ✔️to help the other members find it more quickly.
Hi Daimy,
Do these four tables have common columns, for example 'Project_id'?
Then you can merge these four tables by the common column in power query.
Best Regards,
Link
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
v-xulin-mstf Thank you for your answer. I just tried it and at first it looks like it works. But when i add the new columns to the matrix the values seem to change. Example: Cost in total is 529k, when merged the fields add up to 27Million.
Hi ERD,
Does the total contain duplicate values?
You can create measure for grouping to calculate totals.Best Regards,
LinkIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
