Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
moraadbilbeisi
Regular Visitor

Changing source using variables in Power Query

Hello! I am trying to use a variable to replace 2 values at the end of a webcall I am making in power query in order to automate it for future use. My code is as follows:

 

let
LastMonthNumb = Date.Month(DateTime.LocalNow()) - 1,
CurrentYear = Date.Year(DateTime.LocalNow()),

PreviousMonth = if LastMonthNumb = 0 then LastMonthNumb = 12 else LastMonthNumb,
CorrectYear = if LastMonthNumb = 0 then CurrentYear - 1 else CurrentYear,

 

Source = Json.Document(Web.Contents("https://XXXXXXXX.XXXX/XXX/XXX/XXXXXX/2023/3")),

 

My goal is to put the variables CorrectYear in place of 2023 and PreviousMonth in place of 3 in my source. Any advice? Thank you!

1 ACCEPTED SOLUTION
PhilipTreacy
Super User
Super User

Hi @moraadbilbeisi 

 

This will work

Source = Json.Document(Web.Contents("https://XXXXXXXX.XXXX/XXX/XXX/XXXXXX/"&Text.From(CorrectYear)&"/"&Text.From(PreviousMonth))),

 

Regards

 

Phil



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


View solution in original post

1 REPLY 1
PhilipTreacy
Super User
Super User

Hi @moraadbilbeisi 

 

This will work

Source = Json.Document(Web.Contents("https://XXXXXXXX.XXXX/XXX/XXX/XXXXXX/"&Text.From(CorrectYear)&"/"&Text.From(PreviousMonth))),

 

Regards

 

Phil



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

May 2025 Monthly Update

Fabric Community Update - May 2025

Find out what's new and trending in the Fabric community.