Forum Discussion
Linking multiple tables for one visual
Step 0: I use your data below. (Date: yyyy/mm/dd)
Step 1: I add a 'WBS Element' column to the 'Remedy customer list' table.
WBS Element = [Cat match]&" - "&[Order type]
Step 2: I make a 'Calendar' table.
Step 3: I make a 'WBS-List' table.
WBS-List = SUMMARIZE('Timesheet data','Timesheet data'[WBS Element])
Step 4: I add some relationships below.
Step 5: I make some tables and some matrixs.
You can solve the problem if you can add a "WBS Element" column to the "Remedy data" table and add a relationship.
I don't know the details of your data, so I can't solve the problem, but I'm sure the data you have has the information to add a "WBS Element" column.
Ahh ok I've created a new column in the Remedy data table and used the LOOKUPVALUE DAX formula and that's worked. Thank you so much for your help with this!!