Variables in DAX
Variables can simplify your DAX code, help with debugging and help improve performance. To use variables in your DAX measure you need to declare a variable using the VAR […] Continue Reading…
How to create the Fibonacci Sequence in Python
This blog post will go through how to create the famous Fibonacci sequence in Python.
Each number in the Fibonacci sequence is the sum of the previous two terms.
The sequence […] Continue Reading…
How to change the summarization of multiple columns in Power BI.
Have you ever been faced with the issue where Power BI automatically adds a sigma symbol to the front of your column if it detects it’s a data type […] Continue Reading…
Azure Synapse Series: What is Workload Management (part2)
So in part 1 we found out what Workload Management was and why we wanted to use it. (If you haven’t read that part, please click here and read […] Continue Reading…
How the UNICHAR() DAX Function Enhances Power BI Reports
The UNICHAR() DAX function is a text function that takes a numerical Unicode value and displays its associated character. For example, UNICHAR(128515) will display as:
90% of the information the […] Continue Reading…
Join 2 Python lists together using nested loops
In this blog post I will show you how to join two 2D Python lists together.
The code is in the screenshot below.
Lines 1 – 2 are two lists that […] Continue Reading…
How to export more than 30,000 rows of data from Power BI Desktop.
Have you ever wanted to export a table from Power BI Desktop into Excel just to make sure the DAX you’ve written is performing as expected but ran into […] Continue Reading…
Azure Synapse Series: What is Workload Management (part1)
So you’ve started using Synapse SQL Pools, you’ve scaled up to improve performance, but your queries aren’t going as fast as you’d hoped. You take a look at resource […] Continue Reading…
Dynamic Date Formats in Power BI
Which date format styles should we use if we are building a report that is being consumed internationally?
Remember, 01/12/2021 is December 1st or January 12th depending in which part […] Continue Reading…
My DAX Training Evaluation
Being fairly new to DAX and having recently completed some DAX training I thought it would be good to briefly share my experiences of the courses I have completed. […] 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) |  |
| Jeet Kainth |  |
| Jon Fletcher |  |
| Nick Edwards |  |
| Joe Billingham |  |
| Lewis Prince |  |
| Reiss McSporran |  |
