Forum Discussion

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 solution provided. At least it doesn't work for me. The parameter solution didn't work as it is static in a sense.

Please find the PBIX here.

If I place something like this into the "Yahoo finance" piece resp. URL part

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

I get this

Any idea how to make this work?

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

3 Replies

Mariusz
Community Champion
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
  Not applicable
  6 years ago
  Mariusz,
  
  thank you, almost, I guess, the decimals are getting in the way. Do you know why?
  - 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!

Related content