Power BI

Guidance for Power BI tenant settings.

I was helping a client this past week to calculate the total business hours between a start date/time and an end date/time, taking into account the working days, public holidays and non-working weekends, etc. As is often the case, I thought it would be a great blog article that I [...]Read More »

I have learnt a lot over my 50 something years in life, and one of my greatest learnings is that “it doesn’t matter how much you already know, there is still more to learn”. Hopefully this is one of the reasons you read my blog – because you want to [...]Read More »

The latest blog post explains how to use Power Query to configure and use Power BI Incremental refreshing for the Power BI Dataset

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 dec…

Microsoft just recently announced that it is taking a “new approach to retail”. What’s the new approach you ask??? Well, it is a bit unorthodox. The new approach to retail is to have no retail. This is a bit of a sad news for me as I do a lot of work with Microsoft and have a lot of good friends who work for Microsoft and, therefore, I would much prefer that Microsoft was successful in all of its business initiatives including retail stores. However, as I put my customer hat on, this becomes a much more nuanced issue. I get very concerned when a company does not see its commitments through. I used to buy all hardware for my company from Microsoft because I wanted its store network in case I needed any hardware support. Moreover, I was purchasing largely Microsoft branded hardware as well. Recently we switched to Lenovo, because of apparent innovation paralysis that I observed with respect to the Surface devices. I am typing this on a machine that has double the specs of my old Surface Book 2 at a roughly the same cost. So, when Microsoft drops out of the retail race, I can’t help but worry about what other races Microsoft just might drop out of. I sincerely hope that Power BI and the rest of BI stack are safe as I have never seen any indications to the contrary, but the same could have been said with respect to Microsoft stores just a week ago.

[vc_row][vc_column width="1/1"][vc_single_image media="87885" media_width_percent="100"][vc_column_text]The above video walks you through how to perform looping in Power Query in order to iterate […]

A typical task when cleaning data is to extract substrings from string that follow a certain pattern. In this post I’m going to describe a method that uses the List.Accumulate function for it. …

Today we are excited to announce that three AI Builder preview model types are now generally available.

In my previous blog, I wrote about using Tabular Editor to migrate existing (Azure) Analysis Services models to a Power BI data model. This is pretty awesome already! Once you moved your model to P…

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 …

Few handy keyboard shortcuts I use frequenctly in Power BI

This post is to support my virtual session at London Reactor on 22nd June. It will include the recording and links to the data source and the final Power BI Report. Link to Reactor Recording will go here…. Data Used and Final File Data in a single Excel File Final PBIX File Links to great Resources Guy in a Cube...

(if you downloaded this before 12:40 Jan 20th 2019, please re-download!)   Having demo'd this version for the first time at Microsoft Ignite The Tour London, I have now released this for you all to use and remix! I have completely re-vamped the method of theming Power Apps. No longer do you have to ...

In this post we share our M365 conference presentation on the Power of a Prototype. We explore a common scenario where business users and data analysts need to work together on projects, and how a prototype can allow for greater communication and a better result.

I have taken advantage of many free (some paid) resources the web has to offer… blogs, YouTube videos, books, courses etc. I believe I have seen some of the best the web has to offer. When I …

At the time of writing this, we're preparing for Day #3 of GlobalCon2 [Register to join here]. Day #1 was so informative and I can't thank Microsoft enough for "trusting us" to deliver some of their amazing announcements.One session in particular that resonated with me was around the new "Microsoft Lists" announcement from Lincoln DeMaris. (Note: […]

Build 2020 brought a lot of Microsoft 365 news and announcements for businesses and developers – including the first disclosure of Microsoft Lists. We are pleased to share our vision for Lists – to highlight how you use it to track issues, manage inventory, build out event agendas, report status, ma...

BEFORE WE START, I NEED YOUR HELP. I AM SPENDING MORE TIME THESE DAYS CREATING YOUTUBE VIDEOS TO HELP PEOPLE LEARN THE MICROSOFT POWER PLATFORM. IF YOU WOULD LIKE TO SEE HOW I BUILD APPS, OR FIND SOMETHING USEFUL READING MY BLOG, I WOULD REALLY APPRECIATE YOU SUBSCRIBING TO MY YOUTUBE CHANNEL. THANK YOU, AND LET'S KEEP LEARNING TOGETHER. CARL https://www.youtube.com/carldesouza One of the cool recent announcements by Microsoft … Continue reading New Features – Common Data Service, SQL and Power BI !!!

Increase Report writing efficency by building Shared Datasets. This tutorial shows you how to take a single pbix file and form two files model and report.

I received feedback on my recent blog post on single-column fusion asking about a curious syntax used in the solution. I promised I would do a deeper dive on why it works in my next blog, so here i…

DAX Fusion Optimising Power BI

In this blog I describe a few of the challenges you might face when you have a lot of dataflows. I will describe a few tips and tricks I am applying to sanitize your dataflow approach, organize dat…

In my last tutorial here, you learned how to apply a What-If technique to calculate the estimated active cases of COVID-19. In this part, you will learn how to run running averages to smooth the trend lines of any measure you use. Our analytics objective is simple. The daily new COVID-19 confirmed cases can fluctuate…

In my last tutorial here, you learned how to apply a dynamic running average in DAX. In this part, you will learn how to offset the daily new confirmed cases vertically and horizontally. Horizontal offset - Normalize cases by population Different countries were affected differently by COVID-19. The most common analytic challenge in comparing between…

A common search strategy has to combine multiple items with an AND instead of the default OR. This Power BI file contains two DAX measures solving a search operation with the fancy name: relational division

This blog post discusses model recalculation in Power BI and how you can perform it.

This blog post lists the new financial DAX functions introduced in June 2020.