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.
How about this graph?
This problem of 'the count of WO' could be solved if there was a key column in 'Remedy data' table to set a relationship with 'WBS-List' table, but I am unable to create a key column because I do not understand the meaning of each piece of data.
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!!