cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
michellepace
Helper V
Helper V

Use parameter (defined in power query) in calculated dax column?

Hello there.

I have defined a parameter FinancialYear_Start_Period in power query editor. I would like to use this parameter in a calcuated dax column. Is it possible?

Thank you, Michelle

1 ACCEPTED SOLUTION
Arklur
Resolver II
Resolver II

You could load that parameter into a table, that way you will able to refer to that:

 

// Parameter1
10 meta [IsParameterQuery=true, Type="Number", IsParameterQueryRequired=true]

// ParamTable
let
    Source = Parameter1,
    #"Converted to Table" = #table(1, {{Source}}),
    #"Changed Type" = Table.TransformColumnTypes(#"Converted to Table",{{"Column1", Int64.Type}}),
    #"Renamed Columns" = Table.RenameColumns(#"Changed Type",{{"Column1", "Parameter"}})
in
    #"Renamed Columns"

 

View solution in original post

3 REPLIES 3
v-lionel-msft
Community Support
Community Support

Hi @michellepace ,

 

Unless you load the parameters into the data model.

Right click the parameter in 'Edit Query' -> Check the ‘Enable load’ option.

v-lionel-msft_0-1596591993834.png

 

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Arklur
Resolver II
Resolver II

You could load that parameter into a table, that way you will able to refer to that:

 

// Parameter1
10 meta [IsParameterQuery=true, Type="Number", IsParameterQueryRequired=true]

// ParamTable
let
    Source = Parameter1,
    #"Converted to Table" = #table(1, {{Source}}),
    #"Changed Type" = Table.TransformColumnTypes(#"Converted to Table",{{"Column1", Int64.Type}}),
    #"Renamed Columns" = Table.RenameColumns(#"Changed Type",{{"Column1", "Parameter"}})
in
    #"Renamed Columns"

 

View solution in original post

amitchandak
Super User
Super User

@michellepace , I doubt that. It will not be visible.



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!