Forum Discussion
DAX
I have a data table below where we can see employees worked under which scope on a particular date. I want to create an output table where I would like to see distinct employees worked under which s...
hI prashantg364 ,
Can you please double check? Your sample data does not match with your expected result. For example, there are supposed to be 1, 2, 2 and 2 for each week under SST but yours shows differently. Also, it is unclear whether the output is in a visual or how the data should be loaded into the model.
Anyways, the attached pbix might be what you're looking for.
The output is not correct.
Let me re-phrase my question.
I have data with employee's name & the work done on a particular date. Now I want to summarize my table to know how many unique employees worked in one scope & how many unique employees worked in multiple scopes.