Report builder - how to dynamically change column name in DAX query?

[tkmiro]

Hello everybody.

I came across this problem: I have separate measures for every month of year in my model. Something like this: VALUE_01, VALUE_02, VALUE_03, ... VALUE_12. (don't ask me why it is like this) I need to therefore use different measure based on what period user selects in filter. I don't want to query all 12 measures since it could affect performance by querying large amount of unnecessary data. (or would it? does querying measures affect performance when I don't use them in report?) So what I would like to do is to use query parameter in my DAX query, but I want to modify the column name with this parameter. Let's say I want measure VALUE_04 it should look something like this: [VALUE_@PeriodNumberParameter]

Is something like this possible?

Thanks a lot in advance!

[v-luwang-msft]

Hi @tkmiro ,

As far as I know, there seems to be no way to pass parameters to measure, see the following article：

How to create a dynamic measure name in Power BI?

Best Regards

Lucien

[tkmiro]

Hello, I think what I'm looking for is possible. I found solution online which looks like it should work (and apparently it worked for somebody else) but it does not work for me. You can press "fx" button in dataset properties next to place where you write your query. In expression editor you can put "=" before  your query and edit your query like a string using parenthesis. I tried it and I can concatenate strings in the query, even in column or measure names. However, passing in parameters doesnt work, even though it worked in an online example I've found.

Anyway, thanks for a reply.

[tkmiro]

I found the source where it seems to be working for someone: sql server - How to correctly set expression Query.CommandText in SSRS? - Stack Overflow