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.

DevSpear's avatar
DevSpear
Advocate II
9 months ago

There’s a custom visual that lets you compare YoY variance without writing any DAX — all through simple drag-and-drop actions using the Pivot button.
It also includes three powerful tools: Analytics, Column Visibility Management, and Visual Comparison Charting.
Check out the video for details https://www.youtube.com/watch?v=hVmlZp7qh3Y

Link to visual: https://flexaintel.com/flexa-tables