cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Panto
Regular Visitor

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
Vvelarde 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
Vvelarde 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

Panto
Regular Visitor

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
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Join THE global Microsoft Power Platform event series.

Join THE global Power Platform event series.

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors