Join us for the May session of Power BI Dev Camp with Alex Powers of the Power BI CAT team. Alex will teach you how to get started with creating custom functions to aid in the reusability of transformation patterns and how to add robust documentation to your Power Query queries.
Use Case - Excel offers many number conversion functions and BIN2DEC (Binary to Decimal) is one of them. But Power Query's M language doesn't offer this conversion function. Below are some examples when a binary number is given and Excel's BIN2DEC function is applied on that.
Use case - Somebody asked me if the cell is not showing complete content then how he can see the complete content of a cell and copy the cell content from there. You know something is there as at the end as ... (3 dots) will be there when you see the cell content.
I believe this problem many may be facing, hence it is worthwhile to share the tip here.
Basically, I had advised the person how to see SQL statement when Query folding is happening. And he wanted to copy the SQL statement but display was not showing complete SQL statement.