topic Re: How to Make Calculated Columns Available for Grouping in Power Query in DAX Commands and Tips

How to Make Calculated Columns Available for Grouping in Power Query

StijnHH — Wed, 24 Jul 2024 13:27:27 GMT

Hi everyone,

I am learning PowerBI and having some trouble with making a calculated column available for grouping in Power Query. I have a calculated column: ProductPriceCategory that I created using DAX in Power BI. However, when I go to the Power Query Editor (Transform Data), I can't see this column there. Here’s how I created the column:

DAX

ProductPriceCategory =
IF(
[ProductPriceZscore] >= 2.5, 
"Top category",
IF(
[ProductPriceZscore] >= 1 && [ProductPriceZscore] < 2.5,
"Premium category",
IF(
[ProductPriceZscore] >= 0 && [ProductPriceZscore] < 1,
"Standard category",
"Value category"
)
)
)

Re: How to Make Calculated Columns Available for Grouping in Power Query

HotChilli — Wed, 24 Jul 2024 13:49:48 GMT

"when I go to the Power Query Editor (Transform Data), I can't see this column there" - this is correct behaviour.

You don't see DAX calculated columns in Power Query.

Add a custom column in power query instead

Re: How to Make Calculated Columns Available for Grouping in Power Query

DataInsights — Wed, 24 Jul 2024 13:51:11 GMT

StijnHH,

Power Query can't see DAX calculated columns. You can create that column in Power Query using "if-then-else" syntax.

https://gorilla.bi/power-query/if-function-in-power-query/

Re: How to Make Calculated Columns Available for Grouping in Power Query

StijnHH — Wed, 24 Jul 2024 13:58:05 GMT

Thank you very much for your response.

Am I unable to see the DAX calculated columns in power Query, because they are only performed after they are loaded?

From now on I will create a custom column and group it that way instead.

Re: How to Make Calculated Columns Available for Grouping in Power Query

StijnHH — Wed, 24 Jul 2024 14:05:04 GMT

Seems that I used the wrong window within PowerBi, many thanks!