• DAX: Is the Total Row in a table giving you grief?
    9th July 2018
    If 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 ranges
    15th June 2018
    DAX (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 Excel
    24th May 2018
    Microsoft’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 2018
    There 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 measures
    14th March 2018
    DAX (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 Features
    1st March 2018
    Recently, 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 Reports
    6th February 2018
    Sharing 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...