Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Group by and show earliest date

Hello, I have the next table: ReminderRowID ReminderID ContractNr ContractStartDate ReminderDate CustomerID 1 R1 C1 1-1-2019 3-1-2019 1001 2 R1 C1 1-1-2019 3-1-2019 1001 ...
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Anonymous 

New table=Summarize(table,table[ContractNr],table[ContractStartdate],table[Reminderdate],"Between",datediff(max(table[ContractStartdate]),max(table[Reminderdate]),Day))

 

Thanks & regards,
Pravin Wattamwar
www.linkedin.com/in/pravin-p-wattamwar

If I resolve your problem Mark it as a solution and give kudos.

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Anonymous 
unfortunately it didn't work out for me

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Anonymous  Have you tried the solution which i have suggested?

     

    Thanks,

    Pravin

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Could you please share what output you are getting after table creation?

       

      Thanks,

      Pravin