In a previous post, I showed how to take a tenancy schedule from a real estate brochure PDF and turn it into a Power BI dashboard. In the last post, we focused on retrieving and cleaning the …
The End of DAX and M? How AI and Python Are Transforming Excel
As we delve deeper into the age of artificial intelligence and AI-assisted programming, a question arises: Are the plethora of programming languages in Excel becoming obsolete? With the advent of AI, …
Continue Reading about The End of DAX and M? How AI and Python Are Transforming Excel →
What are the seven wonders of Modern Excel?
I asked ChatGPT: if the 7 wonders of the modern world were modern Excel features, which would they be and why? Here's what I got back: 1. Great Wall of China - Power Query The Great Wall is …
Continue Reading about What are the seven wonders of Modern Excel? →
How to build an Excel data model that matters: Review of Data Modeling in Excel
Data modeling, contrary to be nearing obsolescence, remains crucial for data analysts aiming to enhance their reporting speed and deepen their insights into business operations. Bernard Obeng …
How to use the CALCULATE()
function in Excel Power Pivot
Excel users have access to a wealth of powerful functions through Power Pivot and DAX, but one function stands out as particularly crucial: CALCULATE(). This function holds the key to dynamically …
Continue Reading about How to use the CALCULATE()
function in Excel Power Pivot →
How to create calculated columns in Excel Power Pivot
In a previous post, we looked at how to create calculated column in Excel Power Query. Now, let's explore when and how to perform the same task in Power Pivot: Calculating in Power …
Continue Reading about How to create calculated columns in Excel Power Pivot →