DAX – Getting the Start Date of the following Week
I was recently doing some work for a customer where they wanted to compare their date to the start date of the following week. They also had a requirement to persist the data to the dataset. I thought that this would be a good challenge to use DAX with a calculated column. I most certainly could do this using the…
BI-RoundUp – Power BI (Desktop Release for August – New App Workspace Experience – Power BI World Tour) – Analysis Services (White Paper for AS Scalability)
Here is my weekly BI-RoundUp, and as I thought when I started putting this together yesterday that there would be a release of Power BI Desktop, which there is and not only that an updated App Workspace experience! Enjoy the read! Power BI – Desktop Release for August Well that was pretty quick to get another release of Power BI…
Convert from Seconds to Minutes with a DAX Measure
I was recently doing some consulting work for a customer and they had a column which contained seconds and whilst this is useful it is better to have it shown as Minutes and Seconds, which is easier to relate and compare. Below I will show you how I came up with the DAX measure which converts it from seconds to…
Review of new Features coming to Power BI by Oct 2018 – From Business Applications Summit
I was fortunate to attend my first ever Business Applications Summit in Seattle. I had the pleasure of sharing an Airbnb with Matt Allington, Phil Seamark and Miguel Escobar, it was great to spend time with these Power BI Legends. I also did meet a lot of people and got to chat with people in the Microsoft Power BI team,…
BI-RoundUp – Power BI (Service & Mobile Update – Create Power BI reports from Excel & CSV Files in SharePoint Online)
Here is the weekly BI-RoundUp, so let’s get into it Power BI – Service & Mobile Update As you can see above there now is an option to share a report with the current filter and slicers that are enabled. This is great because it will mean that you can have a subscription report that will send it out every…
Creating a Slicer that also contains a DAX Measure
I got an interesting question from Vijay asking, “How do we do a slicer with data count?” This is what Vijay was looking to achieve as shown below and I always enjoy a good challenge. As I always like to do, is to show how I got to the required result. I currently have got data from my website, which…
Creating a DAX Calculated Column for Today, Yesterday and Next Working Day with Variables
Below was a question from the Power BI Community where the output was to have a calculated column in the Date Table, which would have Today for Todays date, Yesterday for Yesterdays Date, and Next Working Day (Being the following Monday) The challenge was that for the “Next Working Day” it should only be for the next Monday and not…
DAX – Concatenating Values only when values are selected
What I am doing with the DAX below is to only show the concatenation of values if a value is filtered. If nothing is filtered (Selected) then display text to show that nothing has been selected, otherwise display in a concatenation what has been selected. NOTE: If you individually have to select each item, it is still being filtered so…
Reactivated Players DAX Pattern
I had a requirement where my customer was looking to gain some insights into their data relating to reactivated players. The definition used for a reactivated player is a player that has previously played but has not played for a certain number of days. The player then comes back and plays again. So, by this definition the player is reactivated….
Power BI – One Measure dynamically made up from multiple measures (To show Month Estimate for current Month)
Where I am consulting there was a requirement where for the current month they wanted to display the Current Month Estimate for the current month they were in, and to show the historical sales for all the previous months. This makes some sound business sense, since currently month would typically start off with a lower sales amount, which would increase…