Forum Discussion
Calling a constant
Hi Pros,
I'm really new to Power BI (how manny times have you heard that :)) and am really loving the tool.
I have encountered an issue that I am unable to find a solution for - probably because I am asking it incorrectly (don't know all the tecjnical jargon). :)
I have built a 'project' with various visualization graphs to display my monthly stats. I am calling my data from CSV files and have just noticed that one of my values (Target) is actually a constant value and repeated in most of my source CSV files.
If I put that value in another global/parameter file, how can I call the value from the respective queries that I have built so far?
Any help would be greatly appreciated.
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!
2 Replies
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!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.