Forum Discussion

Davidkm's avatar
Davidkm
Frequent Visitor
5 years ago
Solved

Measure with MAX(Column)

Hi,    var a = MAX(Table[column])  var b = MAX(Table[column])  -1   in a return 2020 in b return -1    why?   Thx,  David
  • amitchandak's avatar
    5 years ago

    Davidkm , Try like

     

    var a = MAXX(allselected(Table), Table[column])

    var b = MAXX(allselected(Table), Table[column]) -1

     

    Can you share a sample pbix after removing sensitive data.