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

     

Mariusz's avatar
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'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!