Skip to main content

Power BI

New

table calculations

Vote (9) Share
Q's profile image

Q on 15 Oct 2015 05:43:00

Ability to quickly create calculations based on a table or report that you already have built.

Example: You have a matrix with Countries on the rows, Month/Year as the columns, and Revenue as your values. In short, a revenue, by country, by month matrix. Another BI product I use allows you to click on the revenue, and calculate a month over month growth based on the previous value in that matrix. You can then use that calculation to format the numbers by color, add a shape to make the large growth months stand out, etc....just a quick way to make boring old cross tab reports a LOT more visual.