In this article, we will explain an advanced topic about the M language – using List.Generate to loop over a table. We will combine our knowledge of lists, records, functions, iterations, and looping techniques. Basically, every important object in PowerQuery. Do-while Loop in PowerQuery Do while loop is commonly used in object programming. The idea …
In this article, we are going to talk about cleaning and transforming column names dynamically and in a bulk. The article was inspired by a request from a client who had issues exporting data from its data warehousing program to .csv files. Out of an unknown reason, program was adding random spaces and non-printable characters …
Using M to dynamically change column names in PowerQuery Read More »
When filtering data by date, we can simply use a date slicer which is enough in most cases. We rarely need to filter our data by hours and minutes. However, sometimes this approach is necessary for the sake of the analysis. In this blog, we will examine the scenario where we need to include hours …
In this article, we will see how we can use the self-referencing technique and Dataflows to create incremental refresh with PowerBI pro version.
PivotTables, or pivoting, is by far the best analytical power of Excel. You digest the data and play with it on the fly. Heck, PowerBI is pretty much PivotTables with pretty visuals, just a lot smarter (because of DAX). While PowerBI offers many stunning looking visuals including matrices, they do not include out of the …
When creating a budgeting prediction, most of the time we are creating it on the higher granularities. Rarely we do it on a daily basis. But sometimes we are required to match budgets to actual sales on lower granularities than the one we previously set (e.q. the manager wishes to see how would the budget …
How to split budgets to lower granularity with DAX (PowerBI) Read More »
High cardinality columns are often the problematic part of the data modeling in most environments, including PowerBI. Since the PowerBI data model resides on a columnar database, having high cardinality columns impact both performance and the size of the model. This is especially the case with columns having more than 2 millions of distinct values. …
Optimizing distinctcount with reduced memory consumption in PowerBI (VertiPaq) Read More »
In this article, we will see how to combine different dimensions and facts inside a single matrix table visual. This approach helps us create fewer measures and tables, but at the same time, it provides us with greater design possibilities, like conditional formatting across the whole column even though there are different measures invoked inside …
PowerBI One Measure for Multiple Dimensions/Facts – DAX Read More »
In the report below, you can see how PowerBI is becoming more googled term than Microsoft Excel in most of Western Europe and Australia.
Regardless of the people job title, preparing and analyzing data becomes an integral part of their work. Most people for this purpose use Excel, because it is the fastest and most flexible tool for processing and analyzing data. But as the data sources and analysis needs increase with each day, traditional methods of processing and …
EXCEED Solutions d.o.o.
Drežnička 21, 10000 Zagreb, Hrvatska
OIB: 25417969805
MBS: 081124327
IBAN: HR6523600001102641074
info@exceed.hr
+385 98 9461 471
Ured: Modruška 2, 10000 Zagreb
Designed and powered by Adssential
