Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Adescrit,

As per your query, 

1. the calculation of  "Custom" column >>>

let
    Source = List.Dates(#"Min Date for Main MDM",Duration.Days(#"Max Date for Main MDM"-#"Min Date for Main MDM"),#duration(1,0,0,0)),
    #"Converted to Table" = Table.FromList(Source, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
    #"Renamed Columns" = Table.RenameColumns(#"Converted to Table",{{"Column1", "Date"}}),
    #"Added Custom1" = Table.AddColumn(#"Renamed Columns", "Custom", each Date.From([Date])),
    #"Duplicated Column" = Table.DuplicateColumn(#"Added Custom1", "Custom", "Custom - Copy"),
    #"Changed Type" = Table.TransformColumnTypes(#"Duplicated Column",{{"Custom - Copy", type date}})
in
    #"Changed Type"

 

2. Since the source files contains the validated date. Thus we are taking dates that begins 2000 years ago.

 

Thanks.