I am wanting to create a visualization that shows the total value of sales per month for this year and last year, and also the variance.
Could someone help me out with the steps I would take to achieve this succesfully?
Go to Solution.
You can use PREVIOUS YEAR function to get the previous year value.
Tables: DateTable(Date), Fact(ID,DATE, VALUE)
Relationship: Date to Date(One to many), both cross filter direction.
Get previous year value.
PY = CALCULATE(SUM('Fact'[Value]),SAMEPERIODLASTYEAR('DateTable'[Date]))
Calcualte the diff between current year and previous year
Diff = [PY]- SUM('Fact'[Value])
Create a matrix visual to display the result:
DateTable[Date] to Rows, switch to hierarchy mode and keep year and month, Fact[VALUE] and two measures to Values fields.
View solution in original post
Check out a full recap of the month!
Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.