Forum Discussion

New Member

2 years ago

Solved

Replacing Errors in Power Query

Hello everyone, I am trying to replace errors in one of the columns by the below function but it does not work, what kind of modifction I need to apply in the below code? That is a sample of...

Need Help

m_dekorte

2 years ago

Hi Magdoulin1,

Your requirement is unclear, what are you aiming to achieve?
For example this will get what you appear to be after but other than that ???

let
    Source = Table.FromList( {"May 2023,#(lf)June 2023"}, Splitter.SplitByNothing(), type table[Service Period=text] ),
    insertMinimum = Table.AddColumn(Source, "Minimum", each List.Min( List.Transform( Text.Split([Service Period], "#(lf)"), Date.From )))
in
    insertMinimum

It yields this outcome.

I hope this is helpful

m_dekorte

Resident Rockstar

2 years ago

Hi Magdoulin1,

Your requirement is unclear, what are you aiming to achieve?
For example this will get what you appear to be after but other than that ???

let
    Source = Table.FromList( {"May 2023,#(lf)June 2023"}, Splitter.SplitByNothing(), type table[Service Period=text] ),
    insertMinimum = Table.AddColumn(Source, "Minimum", each List.Min( List.Transform( Text.Split([Service Period], "#(lf)"), Date.From )))
in
    insertMinimum

It yields this outcome.

I hope this is helpful