Forum Discussion
matty_c
5 years agoRegular Visitor
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 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.