One of the most common complaints regarding the capabilities of Power BI and other reporting platforms at large is the ability, or lack thereof, to easily roll up data by month. Power BI, by default, has some capability to do this in the form of date hierarchies.
When you select a DateTime field as a dimension in a Power BI visualization, Power BI utilizes date hierarchies by default. This rolls up the measures to the year level and then enables drill downs into each quarter, month,...
Continue reading →