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…
Power BI – Publish to Web to Remove Grey area on the sides
I was recently browsing the Power BI Forums, where I enjoy helping others with Power BI questions. Not only that, I also learn from other people in the community. In this instance I was unaware that Lukasz Pawlowski had created a really useful site where I could put in the page details for my Publish to Web page, which would…
How many times has my Power BI dataset been refreshed?
Have you ever wondered how many times your Power BI dataset has been refreshed? And if you are using Power BI Pro, you are limited to 8 refreshes a day. This week’s blog post I am going to demonstrate how you can use the Power BI API to view all your data refreshes for a particular dataset. If you need…
Power BI Infographic Update – June 2018
There have recently been quite a few changes and updates to Power BI, so in this blog post I have updated my Infographic. As well as put in references to where you can find more details on the updates that I have made to the infographic. Below are the relevant links Filter and Sort in the Data View in Power…
BI-RoundUp – Power BI (Power BI Desktop June update – Subscribe others to Email Subscriptions – Developer Community for May, Service & Mobile Update)
Here is my weekly BI-RoundUp, and once again the awesome people from the Microsoft Power BI Team have released some additional gifts. Power BI Desktop June Update Here is another month of big updates to the Power BI Desktop. Reporting The first item is now based on your contrast settings, this will be applied to the Power BI Desktop file…
Using the Power BI API with PowerShell scripts – Refreshing your dataset
I know when I started trying to use the Power BI APIs, I was unsure of what I was doing, and how I could get it working. Not only that, but I could see that as with building any cloud platform the APIs have to be there before they can put the skin on and make it easy to use….
BI-RoundUp – Power BI (Help Improve Power BI – Gateway Update for May)
Fortunately, there has not been a lot of activity in the Power BI space, which gives me a chance to catch up on some reading (Beginning DAX with Power BI by Phil Seamark) and to have a bit of a rest. Here are the updates for this week. Help Improve Power BI The Power BI Team has a survey out, in…
Power Query Pattern – Adding Spaces in Text within your data with Camel Case
In this week’s blog post, I created this Power Query Pattern, which I created to add in spaces for CamelCase text within a column. To get this to work for you, all that you do is need to make one change to the code. Below is what the data looked like Then I created the following Power Query Pattern below….
BI-RoundUp – Power BI (Dashboard Theming – Incremental Refresh)
Another week has flown by and there are once again more Power BI Updates, which I really enjoy. But at the same time there is so much content and blog posts that at times it is a bit of a struggle to keep up with what everyone is doing. And with all of that I am still really enjoying being…
Power Query – Renaming Multiple Columns
I was working on a dataset where I wanted to change multiple column names using one step and not having to change them manually. Since there were over 30 columns this would be really time consuming. Below I detail how to complete this in the Power Query Editor, which will replace all the column names for me in one step….