Forum Discussion

Raj_251891's avatar
Raj_251891
New Member
5 years ago

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/...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi  Raj_251891 ,

Here are the steps you can follow：

1. Create Calculation Table.

Table 3 = FILTER('Table',
'Table'[Date & Time]=MAXX('Table','Table'[Date & Time]))

2. Result.

You can downloaded PBIX file from here.

 

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.