ALM Toolkit would not open (When using External Tools from
Power BI Desktop)

I recently got a new laptop and I had to install all my programs again. Everything was going as expected, except when I went to use ALM Toolkit, the program would not open. I would click on ALM Toolkit, I would see it open for a few seconds in task manager and then it would disappear. That led me down...

The post...

 

How to Calculate SUMIFS, COUNTIFS, AVERGEIFS using Power
Query List Functions in Power BI

How to use List.Count, List.Sum, List.Average, List.Min, List.Max Functions in Power QueryScenario:In the following scenario, we will discuss about how to perform the Calculations like the classic Excel Functions, SUMIFs or COUNTIFs or AVERAGEIFs using Power Query List functions.Suppose we have sales table "tbl_Sales" as follows. Based on this table we...

 

Monitoring Power Query Online Memory And CPU Usage

Power Query Online is, as the name suggests, the online version of Power Query – it’s what you use when you’re developing Power BI Dataflows for example. Sometimes when you’re building a complex, slow query in the Query Editor you’ll notice a message in the status bar at the bottom of the page telling you how long the query has been running for and...

 

How to compare Current Snapshot Data with Previous Snapshot
in Power BI

How to Dynamically compare two Snapshots Data in Power BIScenario:Suppose, we have a sample Sales data, which is stored with Monthly Snapshot Codes as per below :Now we would like to compare any of the two Snapshots Data, based on the user selection of the Snapshot_CD.a) If the user does not make any selection, then by default latest or Current Snapshot...