Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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