Forum Discussion
Raj_251891
5 years agoNew Member
Table visualization/ display value based on max date
Hello, I am new to power BI and need you help on below: I have the data as below: alias_no dest Msg_cod Ref No Src status ID Date & Time W W-002 PEES1001 W success 81 21/9/...
amitchandak
5 years agoSuper User
Raj_251891 , All the columns other than Table[Date & Time], do this all column. Create a measure like this and use in Table visual
Max Ref No= lastnonblankvalue(Table[Date & Time], max(Table[Ref No]))