Forum Discussion
jeffprandall
Helper I
Helper IMany to Many Join
I have two datasets I want to join so I can use a slicer/filter to show the total number of incidents based compared to the total number of hours on a job. Hours Dataset Job Name Date Total...
Ashish_Mathur
Super User
Super UserHi,
Create a Job Name table and build a relationship from the Job Name table of both tables to the new Job name table created. Build your slicer from the new job names table and select A1234 there. Write these measures:
Hours = sum(Hours[hours])
Count = countrows(Incidents)
Hope this helps.
jeffprandallHelper I
Helper II ended up creating a Date Table and then joining both the tables based on dates to those and it worked before I saw this.