Use multiple date columns to create matrix

[matty_c]

Hi PBI Experts,

In my dataset, I have 2 columns "Overdue" date and "Scheduled date". I want to create a matrix that has the header for the date, then splits into 2 columns to show a count of all the rows that are scheduled or overdue on that date. i.e. each row may be counted twice if it has both a scheduled date and an overdue date.

This will also then be split into categories based on another column in the dataset.

I can put all the scheduled dates into a matrix OR all the overdue dates into a matrix, but I can't figure out how to do both into the same matrix. Mainly because there are 2 date columns and they can both have different data.

eg:

Thanks in advanced.

[v-janeyg-msft]

Hi, @matty_c 

According to your description, you can create a measure to get the result. But my question is, if you put dates in the columns of the matrix, there will be many columns. The date columns are generally not a small number. Are you sure this is feasible? Does each category correspond to many schedule dates or overdue dates? 'Schedule' or 'Overdue' under each date in the matrix is not the same row of data in the original table. Are you sure that this is logical?

Please add some information, such as the row and column types in the original table, and more specific logic.So we can help you soon.

Best Regards

Janey Guo

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

[amitchandak]

@matty_c , You have to join them with one date table, One join will be inactive. That you have to activate using userelationship

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...

https://radacad.com/userelationship-or-role-playing-dimension-dealing-with-inactive-relationships-in...