cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

Stuck with YoY Comparison with XLSX file

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? Smiley Happy


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

Follow me on Twitter:@PantoMvp
Get in contact on Linkedin: Fabio Fantoni
1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Champion
Community Champion

Re: Stuck with YoY Comparison with XLSX file

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]))

 




Lima - Peru

View solution in original post

2 REPLIES 2
Highlighted
Community Champion
Community Champion

Re: Stuck with YoY Comparison with XLSX file

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]))

 




Lima - Peru

View solution in original post

Highlighted
Helper I
Helper I

Re: Stuck with YoY Comparison with XLSX file

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.

 

 

 

Follow me on Twitter:@PantoMvp
Get in contact on Linkedin: Fabio Fantoni

Helpful resources

Announcements

August Community Highlights

Check out a full recap of the month!

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Solution Authors
Top Kudoed Authors