• Power BI Pro Tip: Role playing dimensions with UseRelationship

    One frequent need in BI is something called a role playing dimension (see http://en.wikipedia.org/wiki/Dimension_(data_warehouse)#Role-playing_dimension for a definition). The classic example of this is a Date dimension that is related to a Sales fact table and used either…

  • Power BI Pro Tip: Sort By Column

    Here is an easy solution to a very common problem when making reports: how do I change the sort of some items from alphabetically to something else? The most apparent sample of this is Months. Let’s say…