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
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
This is a fun video in which we try to solve an interesting DAX puzzle while learning how to use TREATAS() DAX function. As a bonus I also show you how to debug variables that house a table inside. For that I do a bit of a tutorial on CANCATINATEX() function. The data set is … Continue reading Getting Better at DAX: Understanding TREATAS() Function
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/
I know these are not the most politically correct words; however, we cannot build a real Income Statement in Power BI the way we can in Excel. The best we can do is put together something that looks like an Income Statement and hope that our CFO will accept it, knowing very well, that there … Continue reading How to Fake an Income Statement in Power BI (Tutorial)
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 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!
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
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 😦
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???