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)
Category: DAX
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 😦
Power BI & DAX: HASONEVALUE() vs. HASONEFILTER()
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()
Power BI: Tips and Tricks for Building Professional Power BI Model (and a star schema tutorial)
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)
Power BI & DAX Tutorial: How to Calculate Rolling (Moving) Average on Non-Contiguous Dates
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
How to Switch Your Power BI Table to a Different Data Source Type Without Breaking Anything
If your model started out in Excel, but now you are forced to connect to data in a database, you do not have to stress out. Yes, unless you watch this video, you will have to rebuild everything, but if you do watch this video, I will show you how you can move your table(s) … Continue reading How to Switch Your Power BI Table to a Different Data Source Type Without Breaking Anything
Power BI Custom Visual Review: Ultimate Waterfall (Free)
TLDR – I did not like it as it was way to complex and too confusing, would much rather use the Simple Waterfall chart. You have been warned, this custom visual takes work to figure out how to use. It is not very intuitive. However, it has a boat load of features that other charts … Continue reading Power BI Custom Visual Review: Ultimate Waterfall (Free)
KNOWLEDGEBANK.PRO VLOG #2: Channel Update, Two Custom Visual Reviews and a Bit of Ranting
Vlog #2 is up… I talk about the channel growth – 10% in the last week – thank you! I also go over the latest Power BI updates from the team's blog. Basically, nothing super exciting, other than a few cool things that get us closer to a direct query to AS or PBI composite … Continue reading KNOWLEDGEBANK.PRO VLOG #2: Channel Update, Two Custom Visual Reviews and a Bit of Ranting
Power BI & DAX: Data Masking vs. Row Level Security (RLS)
Data Masking is vastly different from Row Level Security (RLS). Often, we get frustrated with RLS because we are trying to solve a data masking problem by using RLS techniques. Data Masking is feature in the security realm that allows us to show the totals for all the data at the high level while allowing … Continue reading Power BI & DAX: Data Masking vs. Row Level Security (RLS)
What to Do When Power BI Totals are Wrong
Have you ever gotten yourself in a situation when your calculation works great on a row by row basis, but when you look at a total, it does not match to the SUM of the individual rows? If so, the problem is not Power BI, the problem is in your calc. The good news is … Continue reading What to Do When Power BI Totals are Wrong
business intelligist 