Forum Discussion
Calling a constant
In Power Query, you can add this to a Parameter
https://powerbi.microsoft.com/en-us/blog/deep-dive-into-query-parameters-and-power-bi-templates/
If you write a query that returns a single value, you can right click > Convert to parameter
You can call the parameter in files by simply typing the name. Note it the name of the parameter has spaces, you'll need the syntax:
#"Parameter with Space"
If you start typing though, intellesense should pick it up. I recommend reading the docs to familiarize with Parameters.
They can be used in Functions, or custom columns etc.
https://radacad.com/custom-functions-made-easy-in-power-bi-desktopAppreciate your Kudos
Connect with me!
In Power Query, you can add this to a Parameter
https://powerbi.microsoft.com/en-us/blog/deep-dive-into-query-parameters-and-power-bi-templates/
If you write a query that returns a single value, you can right click > Convert to parameter
You can call the parameter in files by simply typing the name. Note it the name of the parameter has spaces, you'll need the syntax:
#"Parameter with Space"
If you start typing though, intellesense should pick it up. I recommend reading the docs to familiarize with Parameters.
They can be used in Functions, or custom columns etc.
https://radacad.com/custom-functions-made-easy-in-power-bi-desktop
Appreciate your Kudos
Connect with me!
Thanks so much Steve.
By adding a new column and 'linking' it to my parameter as explained in https://radacad.com/custom-functions-made-easy-in-power-bi-desktop I was able to resolve my issue.