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…
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…
Power BI Visuals now support Custom Formatting for measures using Calculation Groups!
The Power BI team has been doing a lot of incredible work. The most recent update which I got wind of is Custom Formatting of measures is now supported for Visuals. This has already been deployed to the Power BI Service and if you download thelatest version of Power BI Desktop (Version 2.83.5894.961 as at 03 Aug 2020) it has…
Did you know you can query data from AWS S3 into Power BI?
I really enjoy a good challenge, and with my customer they have all their data stored in AWS S3. Whilst there is no native connector, I thought there must be a way for me to get the data from AWS S3 into Power BI. I did a bit of Googling and could not find any suitable solution. I also found…
Validating Power BI DAX measures when using Tabular Editor
I have really enjoyed using Tabular Editor with Power BI, as announced in the latest version of Power BI Announcing public preview of external tools in Power BI Desktop One of the challenges I have found is that it is very easy to create a new measure in Tabular Editor. Due to it currently not having any Intellisense I have…
Showing Dates in reverse order for Tables/Matrix with dates, so that the latest is always shown first in a Power BI Matrix
While doing some work I had a matrix that I had created. What I found was that when I had more Yr-Month values that could fit in the matrix due to having the scroll bar it would show me the older Yr-Months and not the latest ones as shown below. I always like to think what the experience would be…