DAX – Getting the Previous Year to Date Value up to and including the Current Month Selected – Not the entire Previous Year
So for this example it is best explained with an image below, then some additional context afterwards If you look above we have got the [Sum of Sales] for Dec 2010-11 NOTE: This I selected in the Slicer on the right hand side. Then I have created a Year to Date (YTD) measure which is the running total for the Year…
BI-RoundUp – Power BI (Usage Metrics – Mobile Apps May 2017- Stream Data Insights Summit – Processing Suggestion Idea’s for Power BI)
Here is this week’s BI-RoundUp with some great content below. Power BI – Usage Metrics You now have the capability to be able to view the usage metrics for your dashboards and reports in Power BI. This is a great feature, because it now gives the organization the capability to see how well the dashboards and reports are being used,…
BI-RoundUp – Power BI (Office 365 Adoption Content Pack – Embedded Accelerator) – Excel (Get & Transform Updates May 2017)
This will no doubt be a quieter week, leading up towards the end of May and into June when there will be the next wave of updates from the Microsoft Power BI Team You might also notice that I have changed the name from BI-NSIGHT to BI-Roundup, as there was another blogger who has his blog URL as BiInsights, so…
Power BI – Dynamic Banding across all fields
I had a requirement from the customer where I am consulting and what they wanted was to be able to have dynamic banding. So that no matter what they put into the table it would show the banding where it would not go greater than the banding amount. This is easiest shown with an image, so if the band was…
BI-NSIGHT – Power BI (Zoom Charts – Preview Power BI Report Server – Featured Data Stories)
For once it has been a quieter week in the world of BI, so here are the updates below. Power BI – Zoom Charts I have to say that it has been a while since a visual has really impressed me and the Zoom Visuals do just that. They provide an almost natural way to interact with your data via…
Power BI Desktop/DAX – Using Unicode (Arrows) as Measures in a Table
I was helping out in the Power BI Community and I came across the following requirement. The user had sales figures and based on the Previous month, they wanted to have an arrow showing if it was up or down. As well as if there was no data to say that there was no data. So this is how I…
BI-NSIGHT – Power BI (Data Connector SDK, Analytics Challenge, April Service Content Packs, ArcGIS May Update) – Azure (SSAS Model into Azure
After all the announcements last week here are this week’s updates. Power BI – Data Connector SDK I know that this has been something that I have seen asked on the Power BI Community, as well as thought about in terms of having the capability to create your own Custom Data Connector in Power BI. Don’t get me wrong they…
Power BI – Configuring SharePoint/Folder refreshing using On-Premise Gateway
I had a requirement to connect and refresh their files stored in SharePoint On-Premise using the On-Premise Gateway. And are the steps that you can follow in order to connect to files stored within SharePoint On-Premise or files stored in Folders. In my working example below I am going to connect to a SharePoint Folder. You can apply the same steps for a…
BI-NSIGHT – Power BI (Premium, May Desktop Update, New Pricing 01 Jun 2017, Pride 2017, Azure Consumption Insights Content Pack)
I always anticipate that the start of each month will be busy with the updates to Power BI, but this month is an exception with not only the release of the May Power BI Desktop Update, but also a new pricing and capacity model with regards to Power BI Premium. So let’s get into it shall we. Power BI –…
What makes up a Power BI Desktop PBIX File
I know that I personally have been interested in what makes up a PBIX file and in this blog post below I will explain from my understanding what are the different parts that make up the PBIX file. It is rather interesting in that it is actually made up of a few different aspects.