by Matt Allington | Nov 5, 2019 | Excelerator BI
I stumbled across an interesting problem recently when helping someone on a forum. Here is the scenario. Assume there is a help desk that is logging tickets into a system. Each ticket is assigned to … Show the Tickets Assigned to Me (or Others) Read More This post...
by Matt Allington | Oct 31, 2019 | Excelerator BI
I have written a series of articles where I explained different methods of combining data from multiple files into a single workbook/table using Power Query. In the first article, I explained how to create a … Combining Multiple Sheets from Multiple Workbooks Read...
by Matt Allington | Oct 12, 2019 | Excelerator BI
I have been planning for various speaking and training events over the last 6 months and these events are now rapidly approaching. As it turns out, it seems I have a bit of a world … Matt’s Power BI World Tour Read More This post first appeared...
by Matt Allington | Oct 10, 2019 | Excelerator BI
Last week I held a free Power BI webinar for people starting out with Power BI who are wondering why they should invest time in learning about DAX. I had more than 700 people register … Power BI Webinar Overflow Q&A Read More This post first appeared...
by Matt Allington | Sep 30, 2019 | Excelerator BI
Level: Intermediate Recently Microsoft introduced a new function in DAX called REMOVEFILTERS(). This is a very useful and well named function and it does exactly what its name suggests. Its purpose is to act as … REMOVEFILTERS() in DAX Read More This post first...
by Matt Allington | Sep 26, 2019 | Excelerator BI
I was delivering Power BI training in Melbourne last week and one of my students asked if it was possible to show on a report if any filters have been applied. It is a very … Is my Power BI Report Filtered? Read More This post first appeared...
