Forum Discussion

MXSven's avatar
MXSven
Helper I
4 years ago

issue with M language statement

  Hi Everybody   it seems that there is a dependency between StartDatum and EndDatum, means I am reducing the value of the EndDatum variable, but then appearently the StartDatum is equal to EndDa...
Need Help
artemus's avatar
artemus
Microsoft Employee
4 years ago

It looks like you have start and end reversed as normally start is less than end, but you are assigning end to start minus 5 days.

 

As far as debugging goes, you could replace the let ... in #"ChangedType1" with [ ... ], which will turn your let statement into a record containing the value of each variable in the let ... in statement.

  • MXSven's avatar
    MXSven
    Helper I
    4 years ago

    thanks for your feedback,
    below find the adusted code and it's outcoming

     

    let

        Source = (Wertpapierkurs as text ) as table =>

     

    let

     

    CurrentReference_number = Duration.TotalSeconds(DateTime.From(Date.From(DateTimeZone.SwitchZone(DateTimeZone.LocalNow(), 0))) - #datetime(1970, 1, 1, 0, 0, 0))*60*60*24,

    CurrentReference = "=" & Text.From(CurrentReference_number),

    HistoricDataReference = "=" & Text.From(CurrentReference_number-60*60*24*5),

     

        Source = Csv.Document(Web.Contents("https://query1.finance.yahoo.com/v7/finance/download/"&Wertpapierkurs&"?period1"&HistoricDataReference&"&period2"&CurrentReference&"&interval=1d&events=history&includeAdjustedClose=true"),[Delimiter=",", Columns=7, Encoding=65001, QuoteStyle=QuoteStyle.None]),

        #"Promoted Headers" = Table.PromoteHeaders(Source, [PromoteAllScalars=true]),

        #"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"Date", type date}}),

        #"Changed Type with Locale" = Table.TransformColumnTypes(#"Changed Type", {{"Open", type number}, {"High", type number}, {"Low", type number}, {"Close", type number}, {"Adj Close", type number}}, "en-US"),

        #"Changed Type1" = Table.TransformColumnTypes(#"Changed Type with Locale",{{"Volume", Int64.Type}})

    in

        #"Changed Type1"

    in

        Source

     

     


    as you can see in the error message, something is not right
    and I have no idea, why the values are equal.

    Any ideas ?