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)

Power BI & DAX: How to Compare Timeseries with Different Start Dates

Let's say you want to compare time series of two product launches that are six months apart. Plotting data chronologically will not be very user friendly. The best way to do it is to plot them based on number of days from the launch date. This way we can easily see which product grew to … Continue reading Power BI & DAX: How to Compare Timeseries with Different Start Dates

Demystifying DATESINPERIOD (or How to Calculate N Months Average Excluding the Current Month)

Date functions in Power BI are not always easy. And sometimes they can be a little confusing… And sometimes, a little more than just a little.. For no other reason than pure serendipity, I have decided to record a quick video using a calculation I had to write to implement a four-month average logic that … Continue reading Demystifying DATESINPERIOD (or How to Calculate N Months Average Excluding the Current Month)

Power BI & DAX: Making Sense of CALCULATE() and FILTER() Functions

If you get butterflies in your stomach every time you have to use CALCUATE or FILTER functions in your DAX then stick around, as I will try to give you some tools that will hopefully bring that anxiety to manageable levels. This is not a short video, unfortunately. I could not cut it short because … Continue reading Power BI & DAX: Making Sense of CALCULATE() and FILTER() Functions

Power BI & DAX: How to Use Breadcrumbs to Fix the Fatal Flaw of the Filter Pane

in this video I talk about the fatal flaw of the Power BI's Filter pane and how we can fix it with breadcrumbs. What fatal flaw am I talking about? What the heck is a breadcrumb? Well, watch the video and you will find out. https://youtu.be/6HHbPzqhcn8 These are the measures that I have created to … Continue reading Power BI & DAX: How to Use Breadcrumbs to Fix the Fatal Flaw of the Filter Pane

PowerBI & DAX: Three Reasons to Move All Your Measures to the Metrics Table

Metrics tables are great! I argue that all of you measures should be moved into a Metrics table. Don't know what a Metrics table is? Care to know why I think you should move all measures to that table? Please watch the video below and your questions will be answered. My reasons: Makes it easier … Continue reading PowerBI & DAX: Three Reasons to Move All Your Measures to the Metrics Table

Power BI: Getting Better at DAX – Understanding SUMX()

SUMX() is one of my favorite functions, but it can be tricky to understand how it works some times. Hopefully, this video can help you understand this function a little better. https://youtu.be/dY9YniavqMA The points I make in the video: Normally, in DAX we cannot do math using column names for additions and multiplications, however, when … Continue reading Power BI: Getting Better at DAX – Understanding SUMX()

PowerApps in PowerBI: Four Things to Consider to Embed Like a Champ

So, you have decided that you absolutely have to embed a PowerApp into your Power BI report. I am not going to stop you, but I will, however, give a few points to consider before you jump in with both feet and have a less than enjoyable experience. https://youtu.be/p29kzh8W95o Here they are in a decision-making … Continue reading PowerApps in PowerBI: Four Things to Consider to Embed Like a Champ