topic Deducing the numbers from bitflag in DAX Commands and Tips

Deducing the numbers from bitflag

mediaware — Tue, 13 Sep 2022 18:00:04 GMT

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

Re: Deducing the numbers from bitflag

Anonymous — Wed, 14 Sep 2022 06:15:26 GMT

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