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???
The title is pretty self-explanatory, the two Power BI DAX titans are going to collide in this video. Two functions enter the arena but only one will leave... Well, obviously, I am only kidding… The two functions have drastically different purposes and objectives and by the end of the video you will have all the … Continue reading Power BI & DAX: HASONEVALUE() vs. HASONEFILTER()
If you are relative beginner in Power BI / Business Intelligence, you will definitely benefit from this lab/tutorial. First, I go over the best practices with respect to designing your data model. I define dimensions and facts and why not thinking about the layout of your data leads to really bad model designs. After theory, … Continue reading Power BI: Tips and Tricks for Building Professional Power BI Model (and a star schema tutorial)
This review of Advanced Trellis by xViz is an excerpt taken from my Vlog #2 video also available on this channel. In the original video I review Advanced Trellis by xViz and Cards With States by OKViz custom Power BI Visuals. The original video is more than twenty minutes long, so I cut this review … Continue reading Power BI Custom Visual Review: Advanced Trellis by xViz
Rolling Average calculations are easy as long as you don't have to worry about gaps in your dates for which you do not have any transactions. In this tutorial, I boldly take on this challenge and successfully complete the calculation that is able to find the last five days on which the selected product had … Continue reading Power BI & DAX Tutorial: How to Calculate Rolling (Moving) Average on Non-Contiguous Dates