Category: Power Query
How to convert accented characters to unaccented in R or Power BI
Sometimes it’s necessary to convert accented characters to non accented in R or Power BI for text analysis purposes. Accented characters might be a problem in texts with spelling mistakes and spoil the analysis.
Dynamic Power BI map visualization with coronavirus data
With the help of additional custom visualization, it is possible to create pretty awesome dynamic Power BI map visualization to see how things are changing during a time.
How to add leading zeros in R, Power Query, DAX or Excel
Here are multiple examples of how to add leading zeros in different ways and places. In these examples, I will add them to number 123. As a result, I will get 5 digits (00123).
How to combine Excel sheets with Power Query
Here is a simple and easy way how to combine tables from multiple Excel sheets with Power Query in Excel or Power BI. With this approach, merging will continue even if new sheets with new tables will be created in the future.
How to create group index with Power Query or R
It is possible to generate a group index (unique row ids) by one or many groups in Power Query. It comes handy when you have to detect the first or last record in each group. Here is 2 solutions: group index with M language and group index with R.
How to create a flexible calendar table with Power Query
Here is an example of how to generate calendar based on two input values – date of the first day and date of the last day. It is a flexible approach you can generate a calendar for the year 2019 or only next 30 days. M code that you can use in Blank Query is…
How to categorize and group data in time intervals with Power Query
If you have DateTime or time column in your data, then sometimes there is a desire to analyze it by time intervals. With Excel and DAX functions you have plenty of possibilities how to do that, but in Power Query, you have to sweat a little bit. Here is the way how to do that…
Easy way how to make Power BI table from scratch, without an external data source
There are two options: – Power Query function #table – Enter Data feature in Power BI #table function, in my opinion, is a more flexible way if you like to work with M code, but sometimes time-consuming. Here is a reusable solution to quickly build Power Query #table function in Excel with text concatenation.
How to calculate ISO week number in Power Query
I calculated ISO week number in Power Query following instructions from Wikipedia. Here is how it goes. M code is at the end of this post.
How to calculate today’s date in Excel, VBA code in Excel, DAX, Power Query, R, PowerShell, CMD and SQL
No matter what kind of tool you use need to get today’s date remains. Here is how to do that in eight different environments.