Working with Bitmask Database Values Using Excel

In this video, we explore a real-world problem where the database stores an important value (in this case whether a group has administrative rights) in a bitmask format. We export the results to Excel and then use formulas to display the column value and our desired mask in binary format. We then use the BITAND function to determine which of our values have that mask value set.

Subscribe to My Channel

 

My Book: Creating Business Applications with Office 365: Techniques in SharePoint, PowerApps, Power BI, and More