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
    amitchandak
    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.

3 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    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.