Forum Discussion
Select a Column From a Calculated Table Inside a Measure
You mean like the SELECTCOLUMNS function?
https://msdn.microsoft.com/en-us/query-bi/dax/selectcolumns-function-dax
:)
Hey Greg, thank you very much for taking the time to respond.
I tried SELECTCOLUMNS and COLUMNSUMMARY, but both seemed to return a table rather than a column. The description of the SELCTCOLUMNS also says "Adds calculated columns to the given table or table expression."
When I tried to previously pass SELECTEDCOLUMNS to a MIN function, I got an error that only a column can be passed to a MIN. So for example:
MIN(
SELECTEDCOLUMNS(Table1, "newCol", [newCol])
)
Bump
You need to use the "X" versions of the functions like MINX, SUMX, etc.
Sample data would help along with sample expected output.
Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490