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.
Solved! Go to Solution.
Hi @em_001 ,
Please try code as below to create a custom column .
if [Rsvision] = List.Max(
let
_PO = [PO]
in
Table.SelectRows(#"Changed Type",each _PO = [PO])[Rsvision]
)
then [Spend] else null
My Sample and result are as below.
Best Regards,
Yulia Yan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello, @em_001
f = (tbl as table) as table =>
[maxr = List.Max(tbl[Revision]),
cs = Table.AddColumn(tbl, "Current Spend", each if [Revision] = maxr then [Spend] else null)][cs],
g = Table.Group(Source, "PO#", {{"rows", each f(_)}}),
expand = Table.ExpandTableColumn(g, "rows", {"Revision", "Spend", "Current Spend"})
Hi @em_001 ,
Please try code as below to create a custom column .
if [Rsvision] = List.Max(
let
_PO = [PO]
in
Table.SelectRows(#"Changed Type",each _PO = [PO])[Rsvision]
)
then [Spend] else null
My Sample and result are as below.
Best Regards,
Yulia Yan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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.