I thought I would share a Power BI report that I created that can be used to simulate a random drawing of meeting attendants. We just used it in our monthly Austin Texas Power BI User Group meeting that I co-lead. It was used to randomly select a winner for the EDNA Scholarship Giveaway for the month of July.
I’ve attached the PBIX file and Excel file that is used as the source. There are more robust solutions that could have been used but I wanted to create something within Power BI that we could use in our user group meetings since we mainly focus on Power BI.
The Power BI report contains instructions on how to use it and an explanation of the calculations that were used as well. The idea was to simulate a virtual drawing of names that get randomly selected when the “Draw” selection is made within the report. The report is then reset be Deselecting the “Draw” selection, Refreshing the report, and selecting “Draw” again to generate a different random winner.
We plan to use this report in our monthly virtual meetings to randomly select a meeting attendee for the EDNA Scholarship Giveaway for that month. Thanks to EDNA for offering these scholarship giveaways to our Power BI User Group.
I hope you find the attached report helpful. Please let me know if you have any questions about it or suggestions to improve it!
Austin PUG Attendance.xlsx (9.8 KB)