Forum Discussion
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" table, "Out" table should be blank and in in existing method A will be visible.
| Details | Method | Payment | Date |
| in | A | 100 | 3/10/2022 |
| Out | Z | 1000 | 3/8/2022 |
| in | D | 10 | 2/8/2022 |
| Out | H | 50 | 2/24/2022 |
If the latest date is 10th March, then data should be available for the 10. either it could be In or Out or for both. instead of showing all date record.
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))
1 Reply
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))