Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Returning value using MAXX

Hi all,    I've previously had assistance on this, but it doesn't seem to work with a slightly different set of data; so the calculated column is:   LastestContract = VAR ContractNo = 'Table'[...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Anonymous ,

     

    Create a new column to replace the blank values:

    main = IF(ISBLANK('Table'[Main Contract No]),'Table'[Contract],'Table'[Main Contract No])

    Then use the maxx function:

    LastestContract = MAXX(FILTER( ALL( 'Table' ) , 'Table'[main]=EARLIER('Table'[main])), 'Table'[Contract] )

     

    Best Regards,

    Jay

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Anonymous ,

 

Create a new column to replace the blank values:

main = IF(ISBLANK('Table'[Main Contract No]),'Table'[Contract],'Table'[Main Contract No])

Then use the maxx function:

LastestContract = MAXX(FILTER( ALL( 'Table' ) , 'Table'[main]=EARLIER('Table'[main])), 'Table'[Contract] )

 

Best Regards,

Jay

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Ah - thanks - I was so stuck in my way of thinking that I didn't consider making another column for purposes of calculating. 

 

Thanks again!