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
4 years ago

Hello,

 

I'm new to Power BI and still learning. I'm working on a report and I want to show the YoY calculation for Warranty costs. Can someone help me the initial steps? I went through some of the replies but couldn't go past step 1. I have attached a snip of the file that I'm working on.

Thank you.