Forum Discussion

ClaireBear's avatar
ClaireBear
Helper I
4 years ago

How to decode an enum - Bitwise Operations using flag enums for weekdays

Hi,  I have received a dataset that includes flag enums to tell me what days of the week an employee works.  I know that: flag enum 62 means that an employee works Monday to Friday flag enum 126 ...
Need Help
ClaireBear's avatar
ClaireBear
Helper I
4 years ago

Hi Anonymous 

Thank you so much for your response. 

The DayID in the table below is the enum that i need to decode for the days of the week worked, being Monday to Sunday.  So i need to figure out which days of the week value 62 (for example) is.
Im not sure if there is a calculation that can be done in power bi that decodes these values? 
If not, i suppose the solution would be to find out what days these values represent and build a look up table. 

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi ClaireBear ,

    I'm afraid that DAX can't implement such a feature, just by using a numerical value to invert the days when the employees work. Besides the table you provided above, are there any other tables in your model associated with this table? I would like to try to see if there is any other information that can be used as an aid to get the days of the week that employees work.

    Best Regards