SSAS adding columns

Hi,

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.

Regards,

Mazhar

0 REPLIES 0

Helpful resources

Announcements

Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.

Join Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.