Forum Discussion

prashantg364's avatar
prashantg364
Icon for Helper II rankHelper II
2 years ago

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...
Data Modeling
Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
2 years ago

Hi,

I am not sure if I understood your question correctly, but I tried to create a sample pbix file like below.

Please check the below picture and the attached pbix file if it suits your requirement.

All measures are in the attached pbix file.