Forum Discussion

sabeensp's avatar
sabeensp
Helper 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

edhans's avatar
edhans
Community Champion
7 years ago

I don't undersand what you want. You say product A has 2 records in 2013, but in your base table it has 10 records based on the date. What is the "Year" column telling us that the "Date" column is not? In other words, why is the year 2017 but the date is 9/1/2013 for the last record?

 

Then you say "I need only 6/1/2013 record and same for the other years" but then your summary table has 8/1/2013, 9/1/2013, etc in it.

 

I cannot figure out the logic to get from Base to Summary in my head, so I certianly cannot come up with DAX or M to get you there at this point.

sabeensp's avatar
sabeensp
Helper IV
7 years ago

edhansProduct has 2 records in each year, I want the most recent date record of each year.