Forum Discussion
Use multiple date columns to create matrix
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 ...
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.