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….
BI-RoundUp – Power BI (Power BI Update May 2018 – Custom Visuals in Excel – Service & Mobile Update – ArcGIS Online & Plus Subscriptions )
Here is my weekly BI-RoundUp and it is great to see that the monthly update for Power BI is here, as well as some other details of the new items. Power BI – Update for May 2018 As always here are the updates for Power BI Reporting As shown above the first item is that you now can have conditional…
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…
BI-RoundUp – Power BI (On-Premise Gateway Update – Developer Community Update)
Here is this week’s BI-RoundUp. I am hopeful that by this time next week the latest version of Power BI Desktop will be released! Power BI – On-Premise Gateway Update By far the biggest news is the capability to use Custom Data Connectors in the Personal Versions of the On-Premise Data Gateway. The Power BI Team did indicate in the…
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….
Resetting Page back to Defaults using the New Buttons Feature and Bookmarks in Power BI
In this blog post I am going to show how to use the new Buttons feature to reset your page back to all the defaults, using the new Buttons and Bookmarks I have started implementing this on report pages and find it very handy for end users to just reset the page and not have to concern themselves with de-selecting…
BI-RoundUp – Power BI (Drill up, Drill Down Mobile App – USA Facts on Financial Data)
Here is the weekly BI-RoundUp, not too much going on this week, which gives me a little time to breathe! Power BI – Drill Up, Drill Down on Mobile App The Power BI Mobile App has been updated to so that now it is a lot easier to drill up or drill down on the visuals on the mobile platform….
Azure Analysis Services or SSAS Tabular 2017 – How to put in Custom TSQL Server Queries using the SQL Server Window
I have recently been working on SSAS Tabular 2017 for the current customer I am consulting at. Along with this I am starting to see that Power BI Premium features are appearing to lean more towards SSAS, so I personally feel that getting into SSAS Tabular 2017 is a great way to understand and work with a similar version of…