- DAX: Is the Total Row in a table giving you grief?9th July 2018If you are having issues with the total row of tables in DAX, this may be a familiar sight: When actually, all you want is this: So, what’s going on here? Why does my first table multiply the totals together, but my second table sum the values in the...
- DAX: How to group measures into numeric ranges15th June 2018DAX (Data Analysis Expressions) is a useful library of functions used across Power BI, Excel and SQL. Stuart Box, Burningsuit’s owner and trainer who...
- Why Power BI is the future of Excel24th May 2018Microsoft’s Power BI is powerful and easy to use, and with new features being added every week, it is fast becoming the future for business analysis...
- What is the difference between BI reports and dashboards?9th May 2018There is a misconception that the Power BI report is a detailed tabular report and that the dashboard is an interactive visualisations with charts...
- DAX: How to use a slicer to select different measures14th March 2018DAX (Data Analysis Expressions) is a library of functions used across Microsoft SQL, including Excel and Power BI. These operators can be combined to...
- How to Use Power BI Bookmarks & New Features1st March 2018Recently, a range of new features have been added to Power BI. From a user point of view, some of the most interesting are bookmarks, selections...
- How to share Power BI Reports6th February 2018Sharing Power BI reports is a good way to give more than one person in your business access to dashboards and reports, and is a productive feature in...