Report using SQL - Unable to edit under applied steps settings?

Ahh ok I think I get what your saying now! (New to PBI sorry!)

I clicked on the "Prior Fiscal Year - Same Period" table -> Advanced Editor and its a bunch of code but I do see the following line

"......between #(lf)dateadd(year, -1, '"&EndDate&"')...."

Im guessing this is a parameter in the query and thats why I cant see the "Edit Settings" option under Applied Steps?

Sorry and going to sound really silly here to ask this but I tried to re-create your screen shot (blank query with let source ="data") but where do you go to see the "original M code"?

Original M code:

Source = Sql. Database(SQLServerName, DBName, [Query="select * from ["&#"Query3"&"]"

And where do you find the "fetched hidden code"?

The fetched hidden code will be like:

Source = Sql. Database(SQLServerName, DBName, [Query="select * from [data]"

When you refer to "blank query text" do you mean it could be literally any sort of text? Like

your example "data" or "sample1" etc?

I am just a bit lost on how you were able to find that M code and fetched hidden code etc now but I really appreciate your patience! 😀