Forum Discussion
Group aging by date and selected date
Hi everyone,
Using examples online I reverse engineered a matrix table which groups values by the aging between a list of dates and a selected date. Column A (document number) has a list of numbers, and column B (document date) contains a list of dates. Users would like to select a date, and be able to see the aging between the document dates and the selected date. I have this up and running but for a reason I cannot understand, the table returns blank for some date selections (notably any date before 2017).
I have linked the OneDrive PBIX file below and would appreciate it if anyone could take a look - I am hoping I am just missing something obvious.
https://1drv.ms/u/s!AkH_PeScw-iuhbVd4KbuW4b5NPzP1Q?e=ymTJbS
Best regards,
ImranAmi
Now resolved by connecting the source data to a separate date table
1 Reply
- imranami
Helper I
Now resolved by connecting the source data to a separate date table