Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Date for all rows

Hello,   I have a folder with multiple files, everyday there comes a new file in the folder. (it is a summary with all the production numbers each day).   Each file contains the date of that day ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

I fixed it, thanks for the help!

m_dekorte's avatar
m_dekorte
Icon for Resident Rockstar rankResident Rockstar
3 years ago

Hi Anonymous 

 

Give something like this a go

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WCijKTylNLslMLS5JLMksBjKyU/MU8hITixRSK5JTcxSMDIyMdQ1MdQ1MdA3MdQ0MdI0M9SpyiiuUYnVI0W1KkW4zdN2xAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Name = _t]),
    AddDate = Table.AddColumn(Source, "Date", each 
        [ 
            v = Splitter.SplitTextByCharacterTransition( {"A".."z", " "}, {"0".."9"})([Name]){1}?, 
            r = try Date.From( Text.Start(v, 10), "nl-NL") otherwise null
        ][r], type date 
    )
in
    AddDate

 

Ps. If this helps solve your query please mark this post as Solution, thanks!