Why ADDCOLUMNS command doesn't work in PowerBI desktop

DAX DAX Calculations
1

Hi Fellow Power BI Users -

I am currently experimenting some DAX commands and found this issue. Below query works fine in the DaxStudio and returns results but error out in PowerBI desktop. I am using exactly the same model here.

image
image.png760×763 36.7 KB

image
image.png900×401 22.6 KB

image
image.png706×458 9.02 KB

2

Possible to add model to this post so I can test and have a look at it?

Thanks

3

Looking at this again though I think I can see the problem.

ADDCOLUMNS can’t be used within a calculated column.

In DAX studio you need to use it because you are returning an entire table, but within Power BI desktop by the looks of it you are just looking to return the one column so you don’t need it.

All you should need here is the RELATED part.

ADDCOLUMNS is a table function and only returns tables. If you used it with the calculated table feature it would probably work, but you don’t need to do this.

1 Like
4

Thank you very much for your precious time for me Sam. I realized my mistakes.