Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

How to get Latest date data.

we have 3 visuals (in , out and Existing). we want to show the latest date data.   Ex:  we have the below data, so in powr bi Table visula there sould be method A should be available and in "In" ta...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    Anonymous , You need to use a measure like below in table or use that visual level filter

     

    measure =

    var _max = maxx(allselected(Table), Table[Date]) //or use// maxx(all(Table), Table[Date]) 

    return

    calculate(sum(Table[Payment]), filter(Table, Table[Date] =_max))

amitchandak's avatar
amitchandak
Super User
4 years ago

Anonymous , You need to use a measure like below in table or use that visual level filter

 

measure =

var _max = maxx(allselected(Table), Table[Date]) //or use// maxx(all(Table), Table[Date]) 

return

calculate(sum(Table[Payment]), filter(Table, Table[Date] =_max))