I have expanded a table but forgot to add a field so i came back to the step with the Expanded table and just ticked the required field and added it.
STEP DESCRIPTION AS BELOW;
= Table.ExpandTableColumn(#"Filtered Rows1", "Semantic.DimMeterHistory", {"ZFreeDescriptor"}, {"Semantic.DimMeterHistory.ZFreeDescriptor"})
In the step below the above, it now gives me the error as attached that can't find the 'Semantic.CimMeterHistory.Status' record.
STEP DESCRIPTION IS;
= Table.SelectRows(#"Expanded Semantic.DimMeterHistory", each ([Semantic.DimMeterHistory.Status] <> 90))
STEP DESCRIPTION AS BELOW;
= Table.ExpandTableColumn(#"Filtered Rows1", "Semantic.DimMeterHistory", {"ZFreeDescriptor"}, {"Semantic.DimMeterHistory.ZFreeDescriptor"})
In the step below the above, it now gives me the error as attached that can't find the 'Semantic.CimMeterHistory.Status' record.
STEP DESCRIPTION IS;
= Table.SelectRows(#"Expanded Semantic.DimMeterHistory", each ([Semantic.DimMeterHistory.Status] <> 90))