Quick Tips: Converting Hexadecimal, Oct and Binary to Decimal in a Single Power Query Function
If you work with Power BI, this quick tip might come in handy. Converting hexadecimal, octal, and binary values to decimal in Power Query can be done in a single function, as shown in this blog post. Previously, a recursive function was used, but the new non-recursive version is more elegant and efficient. This blog post provides the function and explains how it works, making it easy for Power BI users to integrate into their workflow. If you're looking for a way to streamline the process of converting numerical values in Power Query, this quick tip is for you.
The post Quick Tips: Converting Hexadecimal, Oct and Binary to Decimal in a Single Power Query Function originally appeared on BI Insight.
Published on:
Learn moreRelated posts
Power BI Introduction Power BI Desktop | Power BI Service | Power Query | Data Modelling Data Visualization | Power BI Mobile Data Connectivity
Microsoft Power BI is a powerful and popular business intelligence and data visualization tool or suite developed by Microsoft. It enables use...
SQL Parse String: Parse Function How-To Guide
If you've ever struggled with converting strings of text in SQL Server into a date, number, or some other data type, the PARSE function is her...
Python String to Int: A Guide to Convert Easily
If you're a programmer, you are likely to deal with data type conversions frequently. When dealing with tasks such as user input or parsing nu...
Convert Matrix data in Excel to Tabular Data in Power BI.
Working with Excel spreadsheets often means encountering data in matrix format, but to gain more insight from the data, it is necessary to tra...
How to check if a variable is integer or float or decimal in Power Automate
Checking whether a variable is an integer, float or decimal in Power Automate is a relatively simple requirement, and this blog post outlines ...
Convert CSV to Parquet using pySpark in Azure Synapse Analytics
If you're working with CSV files and need to convert them to Parquet format using pySpark in Azure Synapse Analytics, this video tutorial is f...
Datatype Conversion in Power Query Affects Data Modeling in Power BI
Are you a Power BI developer struggling with data type issues? Look no further. In this blog post, the common challenges arising from inapprop...
Power Query Optimization: Reducing Decimal Numbers
If you're dealing with large amounts of data in Power Query and want to optimize its performance, this tutorial is for you. Here, you'll learn...
Timezone conversion Issue in CRM to BC integration
If you're struggling with timezone conversion issues in CRM to BC integration, you're not alone. Recently, a date issue cropped up when sendin...