Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi guys,
Pretty new to PowerBI, I'm trying to create my first YoY comparison starting from a simple xlsx file.
Despite having read a lot of posts/discussions regarding this topic (and got it done in various different tools), I can't figure out what I'm missing to achieve what I want.
Basically I'd like to have a Clustered Column Chart with CurrentYear vs Previous Year for every Year.
Simple or not?
This is a simple snippet of my xlsx:
ID Order Date Sales
1 28/05/2011 100
2 28/06/2011 200
3 01/01/2012 300
4 28/05/2012 400
5 12/11/2013 200
6 01/08/2013 600
Could you please suggest me how to write those 2 new measure in order to have somthing like CurrentYear and PreviousYear?
Thanks in advance
Solved! Go to Solution.
You need first a calendar table to use Dax Time intelligence functions. You can do this with calendarauto() function.
Then you can use:
TotalSales=Calculate(Sum([Sales]))
TotalSalesPreviousyear=Calculate([Totalsales],Sameperiodlastyear(Calendar([Date]))
You need first a calendar table to use Dax Time intelligence functions. You can do this with calendarauto() function.
Then you can use:
TotalSales=Calculate(Sum([Sales]))
TotalSalesPreviousyear=Calculate([Totalsales],Sameperiodlastyear(Calendar([Date]))
Hi Victor,
the Calendar Table is exactly what I was missing because I thought that I could accomplish YoY comparison with "just" the xlsx file (see other Dashboarding tools).
Thanks a lot.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |