Blog

I quite often work in Power BI with smaller semantic models used for quick ad-hoc reporting, PoCs, and similar scenarios. Across different data sources, I regularly need to create the same types of DAX measures over and over again. In my case, these are most often various sums, averages, and record counts. On top of that, I frequently need measures for tracking changes compared to previous periods (e.g. previous month, previous year), including both absolute and percentage changes. Sometimes I also add color-based measures for conditional formatting, and suddenly this turns into a fairly large amount of repetitive, boring code that has to be written manually.

That’s why I created a macro for Tabular Editor 3 that significantly speeds up this process. Here it is.

When you hear ETL (Extract, Transform, Load), most people imagine specialized tools like Keboola, Talend, Informatica, Pentaho, Microsoft SQL Server Integration Services, or dbt. But sometimes there are moments when you have data in a SQL database and for various reasons you cannot deploy ETL tools. How do I solve this for some clients?

Creating a quick RFM (recency, frequency, monetary) analysis isn't difficult. Visualizing it for end users is more challenging. And that's where another free "toy" of mine, which I've been using for years, will help you. It's a file with all achievable score values (1-5), segments, and recommended follow-up activity. Numerical RFM segments alone don't tell report readers anything; this way you can easily display segment names and sort them appropriately.

Do men or women shop with us more? And who is actually who? Figuring this out isn't exactly easy. Unless, of course, you have a handy database...

Visualizing addresses on maps isn't always easy. You often end up needing to display various metrics at the region and district level, but you don't have that information in your source data. However, if you have Czech or Slovak ZIP codes in your data, you can easily convert them to districts and regions using a free tool I've prepared for you.