Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Sequel: How to make a variable in connection string? (dynamic Epoch in URL)

Hello forum, I would like to come back to the post: https://community.powerbi.com/t5/Power-Query/How-to-make-a-variable-in-connection-string/m-p/73380/highlight/true#M5649 as I think there was no so...
Need Help
  • Mariusz's avatar
    Mariusz
    6 years ago

    Hi Anonymous 

     

    Try wrapping your calculation result in Text.From the error is due to mixed data types.

    Text.From( Duration.TotalSeconds( Date.AddMonths( DateTime.FixedLocalNow(), -1 ) - #datetime( 1970, 1, 1, 0, 0, 0 ) ) )

     

    Best Regards,
    Mariusz

    If this post helps, then please consider Accepting it as the solution.

    Please feel free to connect with me.
    LinkedIn

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Mariusz,

 

thank you, almost, I guess, the decimals are getting in the way. Do you know why?

 

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

I think I got it:

 

 

 

Text.From(Number.RoundDown(Duration.TotalSeconds( Date.AddMonths( DateTime.FixedLocalNow(), 0 ) - #datetime( 1970, 1, 1,0,0,0 ) ) ))

 

 

Mariusz, thank you very much!