Sweden’s population in Power BI

I recently got my hands on some open data from the Swedish bureau of statistics (SCB). Anyone could download this from their site but apparently, not everyone is interested in spending Saturday evenings building Power BI reports (yes, I am about as confused as you are!) and since the...

Streaming datasets in Power BI

I usually try to add three perspectives in my Power BI Reports. Three aspects I find that Power BI is really god at visualising: KPI Trends Details I will go into details on this in future posts, but for now let’s just say that these three pillars are mainly...

Behind the scenes of The Power Challenge

I recently set up the Microsoft Team for the Power Challenge for the contestants to enter as guests before the challenge begins. For any new member who registers on the site above, a flow is triggering an Azure Automation that adds you as a guest to the tenant and...

Merging Cells in Excel lists

Lets say we have this list of people. We know who their managers are and we know whether they like Excel or not. (All users in this blog has given consent under GDPR to have their personal view on Excel processed). Let’s say we want to send out an...

Teamsdagen Studio Give away

On the 14th of October 2020 I had the honor of presenting “Power Virtual Agent & PowerApps + Microsoft Teams = K√§rlek”. During this session I promised a give away in the form of a PowerApp called “Teamsskaparen”! Here’s the link to download the .ZIP-file! Installation instructions Go to...

Calendar Analytics with Power BI

Some time ago I wondered. How good am I at scheduling and accepting meetings into the future compared to more ad-hoc? Essentially how good am I of planning my own time. Being in control. My evening was saved! The result was this Power BI Report! It shows the amount...

Switching currency in Power BI

In one of my recent Power BI projects I stumbled upon the need to switch currencies between SEK and EUR. The company mainly looks at SEK, as their head quarters are in Sweden but it is a global company and many times the number crunchers that dive into the...

The Kaggeholm Event PowerApp

At Altitude 365, we recently held a week long kick off at Kaggeholm outside of Stockholm. This was quite possibly the best thing ever! Instead of having all our conference sessions cramped into a few hours, we had plenty of time to reflect and really work things through. For...

Cross reference with Excel

Now and then, I get questioned about how to make cross references in Excel. Let’s say you have 2 lists and there are common values in both. You want to find for example usernames that exists in both lists. This post will explain how you achieve it using Xlookup....

Simple way to move your Excel tasks into Planner

During Teamsdagen this year I got the great honor of speaking about the PowerPlatform and Ive already made a blogpost about the give away of my session, the FileAnalytics report i Power BI and it’s not time for a blog post about the Flow in Power Automate that I...