Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Unable to load the front end visualization.

Hi Team,

We were able to load the date from 01/01/0001 till today on the backend( tranform editor) but we are not able to load the complete list it into table view( date from 01/01/0001 till 12/31/0099 are unloaded but date from 01/01/0100 till today were loaded successfully ) 

Please find the captures:

 

 

 

Any suggestion or advice will be highly appreciated.

Thanks

General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests

2 Replies

  • Adescrit's avatar
    Adescrit
    Impactful Individual
    2 years ago

    Hi Anonymous ,

    I have a couple of questions:
    1. What is the code you have used to calculate your "Custom" column?
    2. Why would you need a table of dates that begins 2000 years ago?

  • 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.