In the previous post I explained how to create Calculated Groups (Calculated Groups – comparisons and calculated columns in a pivot directed by slicers » Data Empower), here I will talk about how to create different formatting for the calculated items. For those of you created Calculated Groups in PowerBI using Tabular Editor (Tabular Editor),…
Calculation Groups – variances in a pivot directed by Slicers
I want to show a situation how using Calculation Groups we can create a pivot or matrix in which using 2 different drop downs (slicers), a user would compare different versions of data in the pivot and their variances. For example, if in the slicer 1, you select Brand A and in slicer 2, you…
SQL DB too large? Here is how to shrink it
Once in a while, SQL database and log files get cluttered with data that you don’t need that occupy your hard drive space. If you are in that situation and are running low on disc space, you need to periodically clean your log files and shrink your database There are few ways to do it,…
Subtotal Counters within Groups and Subgroups for Calculated Columns
Very often there is a need to calculate counts of various elements within groups or subgroup. This is very useful for calculating ratios. They key element of a ratio is to get the right denominator within desired filter context. Here I will describe the easy way to get any desired count of a group or…
Connect Excel to PowerBI Desktop
There are a few ways to connect Excel to a PowerBI Desktop file. The easiest way meanwhile is to use DAX Studio (can be downloaded for free here: https://daxstudio.org/) Steps are as follows: 1. Open PowerBI Desktop file that you want to connect to. In my case I opened CoronaPBI file that I was working…