topic Re: DAX Bring two columns from different tables, and one table has measures in DAX Commands and Tips

DAX Bring two columns from different tables, and one table has measures

Anonymous — Fri, 21 Apr 2023 15:15:53 GMT

Hi,

I am trying to bring two columns from different tables that are connected but one table has only measures, how can I bring it? Or do I need to create the masure in here? Because I am new and is complicated for me to move it, thanks

Re: DAX Bring two columns from different tables, and one table has measures

johnt75 — Fri, 21 Apr 2023 15:31:42 GMT

Because its a measure and not a column you need to give it a name in SUMMARIZECOLUMNS,

EVALUATE SUMMARIZECOLUMNS ( VALIDATED_PD[m_Group_Currency_Amount], "Total Overdue", [a_TotalOverdue] )

Re: DAX Bring two columns from different tables, and one table has measures

Anonymous — Fri, 21 Apr 2023 15:38:43 GMT

Thanks it works! is the same logic for calculates columns? Or do I need to create it as a measure?

Re: DAX Bring two columns from different tables, and one table has measures

johnt75 — Fri, 21 Apr 2023 15:42:56 GMT

You don't need to specify a name for a calculated column, you can just specify the column, but all the columns need to be before the measures in the SUMMARIZECOLUMNS