Forum Discussion

CarlsBerg999's avatar
CarlsBerg999
Icon for Helper V rankHelper V
4 years ago
Solved

Return adjacent column value based on max

Hi,   Im trying to create a calculcated column, that retrieves a text value from another table. The logic is the following  VAR variable1 = blabla VAR variable2 = blabla   VAR ReturnInvoice =...
Need Help
  • parry2k's avatar
    parry2k
    4 years ago

    CarlsBerg999 try this:

     

    VAR variable1 = blabla

VAR variable2 = blabla

VAR __max = CALCUALTE( Max('Table1'[Column4]))

VAR ReturnInvoice =  CALCULATE(MAX('Table1'[InvoiceID]),
'Table1'[Column2] = variable1,
'Table1'[Column3] = variable2,

'Table1'[Column4] = __max)

     

     

parry2k's avatar
parry2k
Icon for Super User rankSuper User
4 years ago

CarlsBerg999 try this:

 

VAR variable1 = blabla

VAR variable2 = blabla

VAR __max = CALCUALTE( Max('Table1'[Column4]))

VAR ReturnInvoice =  CALCULATE(MAX('Table1'[InvoiceID]),
'Table1'[Column2] = variable1,
'Table1'[Column3] = variable2,

'Table1'[Column4] = __max)