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.

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hello,

 

I am relatively new to Power BI so I'm still fumbling through it.  I have attempted to use this technique in a report and continue to have an issue. As far as I can tell I have followed the steps outlined here. I should be seeing 2015 results in the RevLastYear column next to 2016 but instead only get the Total 30107315 and that is only because I turned on Total row otherwise I have a blank RevLastYear column. I hope I provided enough information to give you an idea of what I'm up against here. Do you think you can help?

 

Year = YEAR(Shipments[Date])

DateMonth = MONTH(Shipments[Date])

SumRevenue = CALCULATE(SUM(Shipments[Total Revenue]))

RevLastYear = CALCULATE([SumRevenue],DATEADD(DATESYTD(Shipments[Date]),-1,YEAR))

 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

I have the same issue here... can any expert kindly share the solution?

 

My data set looks like below...

 

 

 

last_yr_unit = CALCULATE([ttl_unit],DATEADD(Sheet2[Yr],-1,YEAR))

 

As you can see, the last_yr_unit column is all empty from 2007 t0 2014, expect "total" row.

 

 

 

Thank you for advance!