Best Practices for Using Explicit Measures in Power BI
Part 2: Best Practices for Using Explicit Measures in Power BI (Part 2 of a 2 part post about modelling in Power BI) In our previous post we explained the differences between implicit and explicit measuresUnderstanding Implicit and Explicit Measures in Power BI This post builds on that and explains some best practices for using […]
Implicit and Explicit Measures in Power BI
(Part 1 of a 2 part post about modelling in Power BI) In this post we will explain the key differences between implicit and explicit measures in Power BI We will also explain the “Discourage Implicit Measures” feature and its significance Understanding Implicit and Explicit Measures Implicit Measures What are Implicit measures in Power BI? […]
Euro 2024 Quarter Final Results
The quarter finals have finshed But how did our predictions compare to results? Background We have been predicting the results for the EURO 2024 football tournament, with a target of getting 70% correct So far in the group stages we predicted 10 of the 16 teams to qualify for the knock out stages (62%) In […]
Euro 2024 Last 16 Results
We now know who will be in the quarter finals. But how did our predictions compare to results in the round of 16 Background We have been predicting the results for the EURO 2024 football tournament, with a target of getting 70% correct So far in the group stages we predicted 10 of the 16 […]
Euro 2024 Match Predictions Results
The group stages are now completed, the results are in…. How did we do? Background Once again we set to work predicting the outcomes for the EURO 2024 group stages With a target of getting around 70% of the correct resuts This time around We now have a stronger basis for each indicator after running […]
Euro 2024 Match Predictions
The Euro 2024 football tournament starts tomorrow in Germany with the hosts playing against Scotland and I cant wait. For the last few football tournaments I have run a match prediction league for friends, colleagues and other associates I wasnt going to do it this time….It is a lot of work, but its so much […]
Forward Stock Cover
What is Forward Stock Cover? Forward stock cover is a technique used by retailers to determine how long the current stock will last considering forecasted sales quantities It is used to control the levels of stock to help ensure that the stock is held at a appropriate level with the risk of being short of […]
Comparing Year on Year in Power BI
In an earlier post we showed you how to use SAMEPERIODLASTYEAR in power BI to compare data to the prior year The major shortfall of this is that the built in function matches the day of month and month, and does not properly reflect the day of the week If we show these with the […]
How to Sync Slicers in Power BI: Step-by-Step Guide
This post explains how to sync slicers in Power BI, without any complex code Slicers are an excellent way to give your users the ability to explore data, allowing users to use the slicers to filter the data down to particular information of interest. But, if your data has different data sets with common values […]
Using Google Search Console Data in Power BI
Google Search Console is a very powerful tool to measure SEO performance. This post highlights how with a little effort you can use Google Search Console Data in Power BI to create much more compelling dashboards It tracks a vast amount of really insightful data, but the reporting is limited The example below is the […]
