If you are engaged in budgeting and cost analysis it will be useful to know how to create a Win-Loss chart. This is a type of Bar Chart chart which, on the left side, holds negative values (most often the losses), and on the right side positive values (most often the gains). On the left side there can be also shown the costs, and on the right side the revenues. Let’s take a look at how this chart works!
Fuzzy Lookup is an Excel add-in created by a Microsoft development team, and can be used for advanced search and comparison of column values in tables. Why does this serve for? For example, in practice, it often happens that, when entering a name and surname, an error occurs or there is no one-way entry. Fuzzy Lookup allows you to compare the column based on the similarity and display the corresponding results in the new table.
In similar way to the newer versions of Excel PowerBI offers a mechanism that, based on a given dataset, can provide you with visuals, usually the charts that best represent your data. These can be: columns, bars, pie charts … At the same time, along with each one a brief description is provided on the basis of which you can conclude why this visual is proposed. Get ready to know Quick Insights!
When we make PowerBI reports with Scatter chart there is a technique where, by using machine learning mechanisms, data groups are grouped into clusters. Clusters are represented by different colors and in this way it is easier to see the connection between groups of data. Once created clusters can also be used to create other PowerBI visuals.
When you write DAX expressions it is a general recommendation not to overestimate their complexity. It is always better to create several measures and further consolidate them within the new formula. The code is more transparent, and there is a lot less chance to make an error. Since recently DAX also allows making variables. They are used to create measures that will be used to create an expression that returns final result.