Forum Discussion

Time_Traveler's avatar
Time_Traveler
Regular Visitor
9 years ago
Solved

Year over Year calculation

Hi guys, I'm trying to make a calculation YoY for Page Views and Visits in my report and it doesn't work. Can you help me with formulas?
  • Vvelarde's avatar
    Vvelarde
    9 years ago

    Time_Traveler

     

    Hello, 

    To Visits

     

    SumVisits= Calculate([Sum(Table[Visits]))

     

    VisitLastYear= Calculate([SumVisits],DATEADD(Table[Date],-1,YEAR))

     

    YoYVisits = [SumVisits]/[VisitLastyear]-1

     

    To PageViews only change Visits column to Page Views Column.

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

Time_Traveler

 

Hello, 

To Visits

 

SumVisits= Calculate([Sum(Table[Visits]))

 

VisitLastYear= Calculate([SumVisits],DATEADD(Table[Date],-1,YEAR))

 

YoYVisits = [SumVisits]/[VisitLastyear]-1

 

To PageViews only change Visits column to Page Views Column.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

In response to those getting blank values in the LastYear measure, I found the solution was to qualify the date field like so;

VisitLastYear= Calculate([SumVisits], SamePeriodLastYear(Table[Date].[Date]))

My guess is that the automatic date hierarchy introduced in 2018 is the cause of this and that you now need to specify the level in the hierarchy you want. I'm new to PowerBI so my explanation could be totally wrong. But this worked for me.