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.
Daimy is it possible for your to share sample data or sample powerbi file for each of the table, I will try to recreate the same structure in my powerbi file and see if that can help you. Pl. share data in a format which I can copy from.
Hi Negi007,
Unfortunately I have no sample data. I cannot share the data I use, it is confidential. I am attaching two screenshots. I hope that gives some more clarity. The first screenshot shows the values in the matrix. As you can see the amount of hours is changing every month. That is because i choose a date column out of the same table the hours are written (see matrix 2). The other two values are not changing because they are connected to their own date columns in their own tables.