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.
Dear Experts:
Please assist to fix the following error message:
I would like to Filter [AllRev] table based on the CutDate and perform further calculations.
[AllRev] has a column name [MaxDate]
I tried below syntex:
= Table.AddColumn(WholeTable, "Custom", (x) => Table.SelectRows([AllRev], each [MaxDate] <= x[CutDate]))
CutDate AllRev Custom
43105 | [Table] | |
43112 | [Table] | |
43119 | [Table] |
Expression.Error: There is an unknown identifier. Did you use the [field] shorthand for a _[field] outside of an 'each' expression?
Cheers!! Sanjeev Soni + 66 852434420
Solved! Go to Solution.
I think PQ is stating that it cannot find [AllRev]. Try adding the bold below.
Table.AddColumn(WholeTable, "Custom", (x) => Table.SelectRows(x[AllRev], each [MaxDate] <= x[CutDate]))
I think PQ is stating that it cannot find [AllRev]. Try adding the bold below.
Table.AddColumn(WholeTable, "Custom", (x) => Table.SelectRows(x[AllRev], each [MaxDate] <= x[CutDate]))
Thank you Thank you Thank you!!!
Thanks for the super quick reply
If works well
cheers!! Soni
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.