topic Re: DAX Function in DAX Commands and Tips

DAX Function

Wadi-Luca — Sun, 25 Jul 2021 11:55:09 GMT

Hello All,

I have a question regarding DAX Functions: I have tried to search for a function that simply gets data from another table (without changing it) and places it in my DAX Table. However, I cannot seem to find one. At the momment I am just using the "SUM" function, but it is just a temporary solution, as it seems to be changing my data.

Does anyone know of any functions that would simply allow me to enter the table and column that I would like to use in my DAX Table?

Appreciate the help!

Re: DAX Function

samHil — Sun, 25 Jul 2021 13:02:08 GMT

Wadi-Luca
Youcan use related().
More details
https://docs.microsoft.com/en-us/dax/related-function-dax

Re: DAX Function

Fowmy — Sun, 25 Jul 2021 14:25:35 GMT

Wadi-Luca

It depends on the DAX function and where you are calling your table. Based on the context, the column values will be materialized. When you access a table in a calculated column or in a measure, it produces different results, in addition, it can change if you use context modifiers like CALCULATE or CALCUALTETABLE.

To access a column from a table as it is : SELECTCOLUMNS function should help you
.

Re: DAX Function

Wadi-Luca — Mon, 26 Jul 2021 06:09:25 GMT

Thank you! Appreciate the help!

Re: DAX Function

Wadi-Luca — Mon, 26 Jul 2021 06:09:39 GMT

Thank you!