Using the Power Query editor GUI, you can group a column by: count, distinct count, max, min, average, median and all rows. In this article we will show you how to expand your toolbox and perform many other grouping aggregations!
Bad actors are the most frequently occurring alarms which are a nuisance to the operator. Usually, these alarms are broken and their configuration needs fixing e.g. the setpoint is incorrectly set, or the dead band or on/off delay needs modification. It is not a trivial task to count, aggregate and rank alarms over a variable period, especially when the database contains millions of events. This report can be generated within seconds in Power BI using Industrial App Store...
Power BI localization was improved on 2019H2, so it is good time to update localization instructions, as some of the old instructions are not valid anymore. Starting with the 2019-12 release, it doesn't matter if your Desktop is using an English version or not.
Power BI locale is determined by users’ settings on the Power BI server.
Power BI Desktop locale is based on three items: Windows settings, global settings and current file settings.
In thispost, I dive intocreating virtual relationships usingone of the most advanced DAX functions in Power BI called TREATAS.If you can understandthis function, you'llseeitsmany applications across reports and dashboardsthatyou might be creating inside of Power BI desktop.
TREATASis a huge helpinsimplifyingyour data model.The ideabehindusingTREATAS istocreate virtual relationshipsbetween two tableswhere a physical one cannot be used.
Recently, I have been faced with a challenge of pivoting many tables. Every table was completely different, I needed some preprocessing steps, like filtering rows and so on. And I also didn’t want to pivot a huge table in Power Query. The solution? A dynamic pivot written in T-SQL and called from Power Query.