I am using SSAS, want to concatenate values in two different column. E.g. I have Project ID, Project Name columns in 1 table.
I have Supplier Invoices with details in another table which are linked with Project ID.
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.