Forum Discussion

soni27's avatar
soni27
Icon for Helper I rankHelper I
6 years ago
Solved

Filter Nested Tables

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 [MaxDa...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    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]))

     

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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]))

 

 

  • soni27's avatar
    soni27
    Icon for Helper I rankHelper I
    6 years ago

    Thanks for the super quick reply

     

    If works well

     

    cheers!! Soni

  • mshparber's avatar
    mshparber
    Icon for Advocate I rankAdvocate I
    3 years ago

    Thank you Thank you Thank you!!!