Forum Discussion

CMoppet's avatar
CMoppet
Icon for Helper IV rankHelper IV
2 years ago

Stuck Creating a SWITCH measure

Hello 😊   Please can I lean on this great community again to help me with a project I am working on?  I have attached sample data to demonstrate the issue I am having:  https://drive.google.com/fi...
Need Help
CMoppet's avatar
CMoppet
Icon for Helper IV rankHelper IV
2 years ago

lbendlin  Hello.  Thanks for taking the time to have a lookat this 🙂

I have connected the columns that are common to both tables; Machine Brand, Type, Age Bracket, Market, Supplier.

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

Those common columns must come from their own dimension tables.  Do not link fact tables, ever.