Get Power BI Desktop to write the DAX for you
Recently I had to get some data from a Power BI Dataset. At first, I started writing the DAX using the fantastic DAX Studio. Then a thought occurred to me, what if I could get the DAX already written and change it to my requirement. This would save me a lot of time and effort. I love the quote from…
Calculation Groups with Disconnected Tables in Power BI/AAS
Below I will explain how to use Calculation Groups with Disconnected tables. I know that some of this might be able to be done with other calculation groups. I find I have more flexibility when combining Calculation Groups with a disconnected table. Below are some of my previous calculation group blog posts that might also be of interest: Create Currency…
Power Query (M) – Passing Parameters dynamically to a SQL Server Query
I had a requirement where the client wanted the capability to decide how much data to load from a SQL Server Query (TSQL). This was so that they could limit the dataset returned, as at times they did not need all the data. So below I demonstrate how to achieve this. NOTE: This will be slightly advanced because I had to…
Using DAX to calculate Cumulative Target amount split into individual months
I had a requirement to take the overall target amount and split it for each month. But also, for it to be cumulative for each month going forward. The Target amount was 600,000 per month This is what the DAX measure looked like Target by Month = VAR MyTarget = 6 * 6000000 VAR TargetPerMonth = DIVIDE ( MyTarget, 6…
Did you know you can copy & paste images into the Power BI Community replies (And a tip to ensure it is large enough to see)?
I recently found out that I could now copy and paste images directly into a Power BI community reply. Previously I did have a blog post How to paste a screenshot/image into the Power BI Community Forum but it required a few extra steps. This has now been made a lot easier where I can now copy and paste my…
Using Power Query to get data from an API that uses a Username and Password combination
In the blog post I am going to show you the steps that I took to get data from the XE.COM API which uses a username and password to log into the API You might be thinking that I could put in the username and password when I used the Web Connector. My challenge is that I wanted to create…
How to automate your data to always store the last 2 years of data using Power Query
How cool would it be to not have to manually update your dataset to keep data for last 2 Years (last year and this year to the current date)? In this blog post I will show you how you can easily filter dates in Power Query to show dates for last year and year to date by using the GUI…
Creating Dynamic Date Column Headers in Table/Matrix Names in Power BI
I find I do love a good challenge and I find that I get them frequently. I also enjoy sharing what I have learnt with others. In this blog post I am going to show you how I found a way to create Dynamic Date Column Headers for Tables or Matrixes in Power BI. Below is what it looks like…
Has your Power BI App been stuck in “Building App” state? I show one way to solve this.
When working with Power BI Customers there are times I have seen when a new user is starting to use Power BI and they can log in after getting an email for a Power BI App as shown below. It stays in this state no matter what they do. Below is how I have gotten this issue resolved. The first…
How to use SSIS with Power Query to extract data from Power BI Premium and insert into local CSV
I was helping and answering some questions on the Power BI community forums and I came across a question where someone was looking to query data from Power BI Premium using SSIS (SQL Server Integration Services). This is definitely possible and I will show you below how I can use SSIS, to query data from Power BI Premium and store…