Forum Discussion

Elofly's avatar
Elofly
Frequent Visitor
3 years ago
Solved

Last Week Daily Sales Line Graph

Hi everyone!   I am trying to build a line graph where I have the following data: - Y axe: Total Sales - X axe: Days of the week (Monday, tuesday, etc.) - Line A: Last week sales - Line B: Prev...
  • Elofly's avatar
    Elofly
    3 years ago

    Hi Freeman,

     

    At the end I went for this:

    Last Week TTV (-2) =
    var LASTWEEK = WEEKNUM(TODAY()-7,2)
    return
    CALCULATE(SUM(vw_Becca_ZoeBookings[TotalPrice]),FILTER('Calendar Bookings','Calendar Bookings'[Week Number] = LASTWEEK))
     
    Thanks a lot for your help!
     
    Best regards,
Elofly's avatar
Elofly
Frequent Visitor
3 years ago

Hi !

Thanks for your quick answer. All good except, I dont have the WEEK option, only MONTH; YEAR, DATE, QUARTER, I guess I need to create it?

Thanks a lot for your help!

FreemanZ's avatar
FreemanZ
Super User
3 years ago

You are right, there is no WEEK interval. You can try -7 DAY and -14 DAY. 

  • Elofly's avatar
    Elofly
    Frequent Visitor
    3 years ago

    Unfortunately, that would run weeks and not "calendar weeks" (from monday to sunday only)

    • FreemanZ's avatar
      FreemanZ
      Super User
      3 years ago

      What does that mean? Could you please provide a screenshot or upload the simplified report?

      • Elofly's avatar
        Elofly
        Frequent Visitor
        3 years ago

        Hi Freeman,

         

        At the end I went for this:

        Last Week TTV (-2) =
        var LASTWEEK = WEEKNUM(TODAY()-7,2)
        return
        CALCULATE(SUM(vw_Becca_ZoeBookings[TotalPrice]),FILTER('Calendar Bookings','Calendar Bookings'[Week Number] = LASTWEEK))
         
        Thanks a lot for your help!
         
        Best regards,