Forum Discussion

Mauri_Castro_70's avatar
Mauri_Castro_70
Icon for Helper I rankHelper 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.

     

Mauri_Castro_70's avatar
Mauri_Castro_70
Icon for Helper I rankHelper I
2 years ago

Hi Ashish_Mathur 

 

Thanks so much for the help!... This worked as expected. I can't thank you enough!

 

The reason why you were getting blanks for all days is actually beacause when I created the mocked up data, I completely forgot to include some the same Ticket ID numbers from the previous week into the current week. However; once I tried your solution in the actual data; things worked perfectly!

 

Thanks Again!

 

Regards,

 

Mauricio

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
2 years ago

You are welcome.