Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
@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
.
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Thank you! Appreciate the help!
@Wadi-Luca
Youcan use related().
More details
https://docs.microsoft.com/en-us/dax/related-function-dax
Thank you!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
49 | |
26 | |
21 | |
15 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
19 | |
18 |