Forum Discussion
reporting prior fields
HI Anonymous,
Do you mean these type strings are mixed and stored with date values in the same column?
If that is the case, I'd like to suggest you add a custom column to check and extract value if the current row existed with 'Payment Type' strings, then you can use the 'fill down' feature to fill the following rows to remark correspond records.Text.Contains - PowerQuery M | Microsoft Docs
Fill values in a column - Power Query | Microsoft Docs
Regards,
Xiaoxin Sheng
HI Anonymous,
Do you mean these type strings are mixed and stored with date values in the same column?
If that is the case, I'd like to suggest you add a custom column to check and extract value if the current row existed with 'Payment Type' strings, then you can use the 'fill down' feature to fill the following rows to remark correspond records.
Text.Contains - PowerQuery M | Microsoft Docs
Fill values in a column - Power Query | Microsoft Docs
Regards,
Xiaoxin Sheng