I was having a candid conversation with Phil Seamark from DAX.tips about Aggregation Tables. During that conversation, I was asking about patterns in using Aggregation tables. Within that 10 minute conversation I was blow away […]
Understand more about your model then you thought possible! This is part two in our series on DAX Studio. If you missed part one be sure to check out the Introduction to DAX Studio.In this […]
Darren Gosbell & Marco Russo join PowerBI.Tips in a 4 part series on how and why to use DAX Studio! They show us why DAX Studio is the ultimate tool for working with DAX queries! […]
This article examines using the advanced editor in Power Query to better handle when things go wrong. It will also allow custom actions to be triggered using Power Automate, allowing the rest of the data to be refreshed while alerting the owner by email of data source errors. […]
This post will walk through how to pull an estimated household income from a US address. It will be completed all in the Power Query Editor. We will convert this to a function to reuse […]
This post will walk through how to pull daily stock price from Yahoo! Finance, then transform the data using a technique called a query branch. It will be completed all in the Power Query Editor. […]
If you have spent any time working in Power BI, your very first step is to, wait for it… Get Data. Using Get Data will start loading your data into the Query Editor for Extracting, […]
This week I had a number of team members tell me how difficult it was to share a PBIX file and the corresponding data between team members. The department hasn’t committed 100% to the idea of […]
This week I encountered an issue when working with multiple queries in my data model. Here is the source files in case you want to follow along. Here’s what happened. I had a PBIX file […]
In this tutorial we’ll learn how to copy and paste queries to and from the Query Editor. When your working in Power BI Desktop often you will need to share and model the data before […]
Copyright © 2024 | MH Magazine WordPress Theme by MH Themes