Hi Guys,
I have a power bi report (see attached)
I am able to make a matrix with Date, Inspection1, Inspection2, etc; which indicates if the inspection has been done or not.
And a second Matrix with Date, and Crew.
I make a single matrix that shows the following fields: Date, Crew, Inspection1, Inspection2, etc
(I need to know: the date, which crew is responsible for the inspections that day, and which inspections have been completed that day)
I have tried merging the data without any luck.
I have set the Power Bi to look like what the final combined matrix should look like.
Any help would be great.
Thanks
Alternative question (same problem):
"iAuditorv05V02" contains multiple instances of the "Crew" Field, how can i makemy Power Bi show only one "Crew" Field?
Thanks
Bookmarks