Deducing the numbers from bitflag

[mediaware]

Hi There,

Have a question that i've been trying to find a solution for but no luck so i hope someone here cld. provide a solution

Here goes:

I have a State colum with an integer that is made up of underlying bitflags

Thanks to the internet i've got a function that can give me the binary value of the integer.

e.g. 6 is 0000000110

My question is - how to get the 'binary value' as an array of or comma separated values

e,g. 6 is 2,4

Kind regards

[v-yangliu-msft · Accepted solution]

Hi  @mediaware ,

Here are the steps you can follow：

1. Create calculated column.

123 =
CONCATENATE(
    POWER(
    2,
    LEN('Table'[Column1])-
    FIND("1",[Column1])-1) ,
CONCATENATE(
    ",",
 POWER(2,
    (LEN('Table'[Column1])-
    FIND("1",[Column1])+1)-1
    )))

2. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly