Forum Discussion

sabeensp's avatar
sabeensp
Icon for Helper IV rankHelper IV
7 years ago
Solved

Recent Record based on Max Date

Hi,   I have a table called BaseTable, which has multiple record for each product, I need to create a new table which has only records of product with most recent date of each year. Product ...
Need Help
  • v-piga-msft's avatar
    v-piga-msft
    7 years ago

    Hi sabeensp,

     

    By my tests, the calculated column of TomMartens is helpful. You could drag this column to visual level filter and only show the value yes.

     

    For your problem, what's data type of your BaseTable'[Year]? Column or calculated column or measure?

     

    Best  Regards,

    Cherry

sabeensp's avatar
sabeensp
Icon for Helper IV rankHelper IV
7 years ago

TomMartensWhen I try to declare var thisYear = 'BaseTable'[Year], it does not allow me to Pick "Year"

TomMartens's avatar
TomMartens
Icon for Super User rankSuper User
7 years ago

Hey,

 

can you please share a pbix file, upload the file to onedrive or dropbox and share the link.

 

Regards,

Tom