Forum Discussion

hiren89vora's avatar
hiren89vora
Frequent Visitor
4 years ago
Solved

Calculate Table Formula

Hi All,   Can you please help me with the below requirement.   I have existing table(Table_1) with below details but need to create calculated table which has max date from each id.   (Table_1)...
Need Help
Show and Tell
Tips and Tricks
  • ryan_mayu's avatar
    ryan_mayu
    4 years ago

    hiren89vora 

    pls try this

    Table 2 = ADDCOLUMNS( SUMMARIZE('Table','Table'[Id],"date",max('Table'[Date])),"amount",maxx(FILTER('Table','Table'[Id]=EARLIER('Table'[Id])&&'Table'[Date]=EARLIER([Date])),'Table'[Amount]))

ryan_mayu's avatar
ryan_mayu
Super User
4 years ago

hiren89vora 

pls try this

Table 2 = ADDCOLUMNS( SUMMARIZE('Table','Table'[Id],"date",max('Table'[Date])),"amount",maxx(FILTER('Table','Table'[Id]=EARLIER('Table'[Id])&&'Table'[Date]=EARLIER([Date])),'Table'[Amount]))