Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
I would like to check some flags in a column of a table, but it seems that I may not know the Power Query or DAX sintax for this... the SQL code for this would be like: [...] WHERE Flags & (1 << 28) [...].
Can anyone help me out with this, please?
Solved! Go to Solution.
Hi @Anonymous,
I'm not clear about your operation about "<<".
Please have a reference of the links below.
https://social.technet.microsoft.com/wiki/contents/articles/757.power-bi-dax-operator-reference.aspx
https://docs.microsoft.com/en-us/powerquery-m/number-bitwiseand
If you need further help, please share some data sample and your desired output so that we can understand your scenario better and get the solution.
Best Regards,
Cherry
Hi @Anonymous ,
Have you solved your problem?
If you have solved,could you please share your solution or accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.
If you still need help, please feel free to ask.
Best Regards,
Cherry
Hi @Anonymous,
I'm not clear about your operation about "<<".
Please have a reference of the links below.
https://social.technet.microsoft.com/wiki/contents/articles/757.power-bi-dax-operator-reference.aspx
https://docs.microsoft.com/en-us/powerquery-m/number-bitwiseand
If you need further help, please share some data sample and your desired output so that we can understand your scenario better and get the solution.
Best Regards,
Cherry
@v-piga-msft thanks for your help! I found an alternative meanwhile, but your documentation refference would have been a viable option too!