Tutorial: How to Calculate an Average of the Best using AVERAGEX() and ADDCOLUMNS() Functions

This is a fun tutorial where we will learn how to calculate average of the highest values that might be spread across different time periods. A good example is figuring out what would be a good proxy for the highest temperature for IL in July. If we simply take one reading for the highest day … Continue reading Tutorial: How to Calculate an Average of the Best using AVERAGEX() and ADDCOLUMNS() Functions

Getting Better at DAX: Having Fun with Running Totals

This is a fun little tutorial that will give you another chance to practice you CALCULATE() and FILTER() functions skills. Running totals are a common problem that we have to deal with. To illustrate this problem, I created a sales dataset for innovation products. In our example, after the product reaches $1m in global sales … Continue reading Getting Better at DAX: Having Fun with Running Totals

How to Stay Current with Power BI Updates and Roadmap

In this video I cover several official sources from Microsoft for staying current with Power BI updates and road map. The important links are below. https://youtu.be/YVcATKT0Ygs Roadmap: 2020 Release Wave 1 Plan: https://docs.microsoft.com/en-us/power-platform-release-plan/2020wave1/ 2020 Release Wave 2 Plan: https://docs.microsoft.com/en-us/power-platform-release-plan/2020wave2/ PDFs: Wave 1: https://go.microsoft.com/fwlink/?linkid=2116925 Wave 2: https://go.microsoft.com/fwlink/?linkid=2134934 Ideas: https://ideas.powerbi.com/ Power BI Blog: https://powerbi.microsoft.com/en-us/blog/

Super Quick Review of Cards with States by OKViz (Custom Power BI Visual)

This super quick review of Cards with States by OKViz is an excerpt taken from my Vlog #2 video also available on this channel. In the original video I review Advanced Trellis by xViz custom Power BI Visual. This video is just a couple of minutes long, but if you are short on time, my … Continue reading Super Quick Review of Cards with States by OKViz (Custom Power BI Visual)

Three External Tools in Power BI Desktop – Must Start Using them NOW!

Three external tools can now be launched from PBI Desktop. These tools are not new, but with the July release of PBI Desktop, they just seem to work better, and the experience is a lot more seamless, as these tools can now auto-connect to our open models. The tools I am talking about are the … Continue reading Three External Tools in Power BI Desktop – Must Start Using them NOW!

My Review of the New Microsoft Azure Map Power BI Visual: NO GO as is, but has lots of potential

As promised, I bring you a review of the new Azure Map Power BI visual from Microsoft (now available in the July 2020 release of Power BI Desktop). Few tragic flaws make it unfit for duty yet, but the potential is there. I am excited for V2. This video is not of how-to variety because … Continue reading My Review of the New Microsoft Azure Map Power BI Visual: NO GO as is, but has lots of potential

Power BI Desktop: Calculation Groups are IN, but there is a MAJOR BUG :(

I do not know if I should be jumping up and down or gently sobbing right now... The Calculation Groups are finally available in Power BI Desktop!!! Unfortunately, there is an issue with Line Charts that will prevent me from using this feature until the bug gets fixed. However, this is a major step in … Continue reading Power BI Desktop: Calculation Groups are IN, but there is a MAJOR BUG 😦

New Azure Maps Power BI Visual – Would You Pay Extra for a Better Map Control???

Would you pay extra if you could get a better Map control in Power BI? I would, but I would have to understand how much and what exactly I am getting myself into. Looks like we are getting a new Map visual from the Azure Map team that at least on paper promises to address … Continue reading New Azure Maps Power BI Visual – Would You Pay Extra for a Better Map Control???