Data Bear’s Monday Motivation Blog Post
If you missed last weeks tip on Bin Groups in Power BI please visit the link provided. Today the Data Bear team will unpack a very simple but powerful to compare year to date values with a measure.
Comparing year to date revenue, sales, profit, or any other business metric is invaluable for companies to make quick decisions. This allows businesses to identify why sales might be better or wore than previous years. We will show you today how a simple measure can resolve this.
To compare year to date revenue with a measure we will need a variable that identifies the month of the year. This variable is used in our measure to filter any given value in a certain year to only show the values of the months that has passed year to date.
Comparing year to date values with a measure
Let’s create a report that compares the year to date revenue against previous years by region and product. We simply create a variable that evaluates in which month we are. After that we make use of the calculate function to determine the revenue for the year to date.