Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
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.
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.
@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]))
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
93 | |
77 | |
65 | |
53 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |