I am trying to format a dataset for venn diagram in power bi. I want to find out how many employees have done Morning, afternoon and evening shifts and combination of all three. For example, an employee 1 has done both Afternoon and Evening shift.
Current DataSet :
Any views on this topic is appreciated !
Go to Solution.
You may create the tables with SUMMARIZE Function.Attached sample file for your reference.
"Morning", MAX ( 'DataSet'[Morning] ),
"Afternoon", MAX ( 'DataSet'[Afternoon] ),
"Evening", MAX ( 'DataSet'[Evening] )
View solution in original post
Join us in the third Triple A event!
It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.
Make sure you didn't miss any of the things that happened in the community in January!