Forum Discussion

imranami's avatar
imranami
Icon for Helper I rankHelper I
6 years ago
Solved

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

  • Now resolved by connecting the source data to a separate date table