Forum Discussion
Solved
Creating a calculated table to only show the most recent value of in a column
I have a table that contains customer name, customer id, funds, AUM (a monetary value) and a date column. The issue I have now is diffrerent date entries have different AUM values for each customer a...
Hi Balos ,
Try to create a new table like below:
Table2 = FILTER ( 'Table', 'Table'[Date] = CALCULATE ( MAX ('Table'[Date] ), ALLEXCEPT ( 'Table', 'Table'[Customer id] ) ) )Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
V-lianl-msft
Community Support
Community SupportHi Balos ,
Try to create a new table like below:
Table2 =
FILTER (
'Table',
'Table'[Date]
= CALCULATE (
MAX ('Table'[Date] ),
ALLEXCEPT (
'Table',
'Table'[Customer id]
)
)
)
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.