Forum Discussion
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 ...
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
TomMartensWhen I try to declare var thisYear = 'BaseTable'[Year], it does not allow me to Pick "Year"
Hi sabeensp,
Have you solved your problem?
If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.
If you still need help, please feel free to ask.
Best Regards,
Cherry