The FREQUENCY function is used to calculate how often certain values in a given range are repeated. This is an array function, and we can use it to calculate a distribution by which we can see how many points students have scored on a test and for other similar statistical analyzes. To help you understand how the function works will also illustrate this with a simple chart …
One of the earlier posts referred to date hierarchies, a relatively new functionality that allows the month, quarter, or year to be automatically created based on a column containing a date (depending on the data that column contains). This can cause a problem with previous reports that contain dates, and the user wants to see them as originally created. How to solve this?
Power BI is, for the most part, used for business reporting purposes, and the ultimate goal is to publish company data in the cloud, along with related reports, and then create reporting dashboards that provide the information necessary to support decision making. A free Power BI subscription can also be used for this, but I still recommend that you use (purchase) a Power BI Professional license. Why? More about this in the text that follows …
When working with graphical objects in MS Office applications there is often a need to integrate multiple objects within one group so that we can move and manage them more easily. As of August 2019, Power BI Desktop has the option to group two or more objects, and in the text that follows you will be able to see how it is used.
Key Influencers is a visual that has been available to Power BI Desktop users since July 2019, and allows measuring the impact of a given component (dimension) on a reporting metric. It can be useful to show us components that differ from the average, as well as segments that affect it and require additional attention. The information we receive in this way can help us rethink our sales strategy.