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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Power Query parameters

I need to figure out how to perform operation on query parameters. I undertand how to set them up for a query and input them like this for example; "&parameter1&".

 

But I want to be able to perform operations on parameter 1. So if for example parameter1 was the current year 2018, I would also want to be able to add in the M code the previous year of 2017. However when I try something like; "&parameter1 - 1&" I get an error. 

 

Any help or direction would be great.

 

Thanks,

 

2 REPLIES 2
v-juanli-msft
Community Support
Community Support

Hi @Anonymous

Do you need to select 2018 from parameter, then filter the data with date 2018 and 2017?

 

Best Regards

Maggie

Anonymous
Not applicable

@Anonymous,

Essentially the & symbol means concatenation, so you have to do something like this:

" ...." & Parameter1 & " - 1" & " ...."

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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