My Experience of SQLBits 2020
A few weeks ago, Purple Frog attended SQLBits 2020 (the largest data conference in Europe). This year the event had a change of pace as the whole conference was […] Continue Reading…
Speaking at Data Platform Summit
I’m delighted to have been selected to speak at the Data Platform Summit (DPS), a virtual conference from 2nd to 4th December 2020, with Data, Analytics and Machine Learning […] Continue Reading…
How to block the creation of a classic workspace in powerbi.com when a new MS Team is created!
There is now a new tenant setting for Power BI admins to prevent users from creating classic workspaces in Power BI! This includes from places like MS Teams! Hurrah!
If […] Continue Reading…
My experience in obtaining an MCSE
Background
I have recently completed my MCSE in Data Management and Analytics, and I wanted to share my experience of working towards and passing the exams that have led to […] Continue Reading…
How to delay a Python loop
In this blog post, I will run through 3 different ways to execute a delayed Python loop. In these examples, we will aim to run the loop once every […] Continue Reading…
SSAS Tabular Calculation Groups – avoid using SELECTEDMEASURE or ISSELECTEDMEASURE
Introduction:
There is a very serious limitation in the behaviour of calculation groups when using the SELECTEDMEASURE or ISSELECTEDMEASURE functions, and we recommend not using them. Why? If a user […] Continue Reading…
ADF: Where have my connections gone?
If you’ve been doing any development work in ADF this week you might have noticed that “Connections” has moved. But where has it gone?
The old location
When you click onto […] Continue Reading…
Using ConcatenateX in PowerBI to return multiple values.
In this blog post we’ll take a quick look at using ConcatenateX function to view a concatenated string of dates where the max daily sales occurred for a given […] Continue Reading…
Regular Expression to get tables from SQL query
If you’ve not come across regular expressions (RegEx) before then you’re missing out, they’re an incredibly powerful tool for matching, extracting or validating patterns of text.
I had a use […] Continue Reading…
Sorting a Power BI table by multiple columns
A common request that is raised by clients is how to sort a table in Power BI by multiple columns, in the same way you can in Excel.For a […] Continue Reading…
The Frog Blog
Team Purple Frog specialise in designing and implementing Microsoft Data Analytics solutions, including Data Warehouses, Cubes, SQL Server, SSIS, ADF, SSAS, Power BI, MDX, DAX, Machine Learning and more.
This is a collection of thoughts, ramblings and ideas that we think would be useful to share.
Authors:
| Alex Whittles (MVP) |  |
| Reiss McSporran |  |
| Jeet Kainth |  |
| Jon Fletcher |  |
| Nick Edwards |  |
| Joe Billingham |  |
