issue with M language statement

[MXSven]

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

Any Ideas ?

Is there a way of debugging modus in the advanced editor, where I can see what the value in each step of the variable is ?

[artemus]

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]

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 ?