Forum Discussion
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 and I only need to see latest value of AUM. I don't know how to create a calculated column to do this.
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.
2 Replies
V-lianl-msftCommunity Support
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.- amitchandak
Super User
Balos , if need a column, but column will not filter , you need filter in visual
New column =
var _max = maxx(filter(Table, [customer id] =earlier([customer id]), [Date])
return
maxx(filter(Table, [customer id] =earlier([customer id] && [Date] =_max), [AMU])
a new measures
lastnonbalnkvalue(Table[Date], max(Table[Amu]))or
calculate(lastnonbalnkvalue(Table[Date], max(Table[Amu])),allexcept(Table, Table[Customer ID]))
