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.
Thank you so much for sticking with me here. So this is what I'm trying to achieve but when adding the Count of WO ID, it is giving the same number for each WBS element category, but it should be showing:
External Customer 1 - provision: 2
External Customer 1 - Cease: 1
External Customer 2 - Cease: 1
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!!