https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/SSAS-adding-columns/m-p/411854#M156524 <P>Hi,</P><P>&nbsp;</P><P>I am using SSAS, want to concatenate values in two different column. E.g. I have Project ID, Project Name columns in 1 table.</P><P>I have Supplier Invoices with details in another table which are linked with Project ID.</P><P>&nbsp;</P><P>I want to show my project id and name in one row. like "12345 - Test Project" and then i will display invoice detials associated with each project.</P><P>&nbsp;</P><P>Regards,</P><P>Mazhar</P> Mon, 07 May 2018 11:21:10 GMT mazhar555 2018-05-07T11:21:10Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/SSAS-adding-columns/m-p/411854#M156524 <P>Hi,</P><P>&nbsp;</P><P>I am using SSAS, want to concatenate values in two different column. E.g. I have Project ID, Project Name columns in 1 table.</P><P>I have Supplier Invoices with details in another table which are linked with Project ID.</P><P>&nbsp;</P><P>I want to show my project id and name in one row. like "12345 - Test Project" and then i will display invoice detials associated with each project.</P><P>&nbsp;</P><P>Regards,</P><P>Mazhar</P> Mon, 07 May 2018 11:21:10 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/SSAS-adding-columns/m-p/411854#M156524 mazhar555 2018-05-07T11:21:10Z