Forum Discussion

Panto's avatar
Panto
Icon for Helper I rankHelper I
10 years ago
Solved

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 ...
Need Help
  • Vvelarde's avatar
    Vvelarde
    10 years ago

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

     

Vvelarde's avatar
Vvelarde
Icon for Community Champion rankCommunity Champion
10 years ago

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

 

  • Panto's avatar
    Panto
    Icon for Helper I rankHelper I
    10 years ago

    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.