Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Employee diversity by date - expanded table?

Hello! I have diversity data for my company in the below format. My table is called DEI Detail   Employee ID, Start Date, Term Date, Gender, Race   I need to be able to use this data much more d...
Need Help
AlB's avatar
AlB
Icon for Community Champion rankCommunity Champion
5 years ago

Anonymous 

I feel like I need to expand this somehow... I have 634 employees and there are 365 days in a year so that would give me over 200k rows. I don't want to use excel.

No need to do at. At all. Best to use a date table whose fields you can use as axis for the chart.  Then create a measure to calculate the number of people employed at the specified time. You can use slicers to dynamically look at what you need: race, gender...

Have a look in the forum. This has been solved many times.

 

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers