Forum Discussion

Mauri_Castro_70's avatar
Mauri_Castro_70
Helper I
2 years ago
Solved

Beginner needs help creating Matrix or Table Showing Previous Week Tickets vs Current Week

Hi;   I need help creating either a table or a matrix that looks something like the example below. Where i am able to show how many tickets I had in the previous week (weekdays only / Networkdays)....
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    2 years ago

    Hi,

    In the filter section, i have chosen the current week offset as 0.  I then wriote this measure

    =Measure = CALCULATE([Total Tickets],FILTER(VALUES(Data[Ticket ID]),[Previous_Week_Tickets]>0&&[Current_Week_Tickets]>0))

    I get a blank for all days.  For Friday of the current week, there are no id's that existed on the Friday of the previous week so blank is the correct answer.  I have not checked for the other days.

     

Ashish_Mathur's avatar
Ashish_Mathur
Super User
2 years ago

Hi,

So would it be correct to say that 220 ticket were sold on Monday of the previous week?  Do you have

  1. A Date column in the Data Table; and
  2. A calendar Table; and
  3. A week number column in the Calendar Table
  • Mauri_Castro_70's avatar
    Mauri_Castro_70
    Helper I
    2 years ago

    Hi Ashish_Mathur 

     

    The tickets columns actually refer to "open/active" service tickets in previous and current weeks respectively. I need a calculated column or measure that gives me the total of active tickets from last week that are still open in current week (as part of the 275 tickets in current week).

     

    To answer your questions 1, 2 and 3; the answer is yes! I have all of them.

     

    Thanks so much for the support!

     

    Mauricio 

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      2 years ago

      Share the download link of the PBI file.

      • Mauri_Castro_70's avatar
        Mauri_Castro_70
        Helper I
        2 years ago

        Hi again Ashish_Mathur 

         

        Due to company policy I cannot share the file. I will prepare some mocked up data file and share it tomorrow. I am located in Central America and it is already late... plus I am away from my computer. 

         

        Thanks