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…
Month: June 2020
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…