Forum Discussion
Beginner needs help creating Matrix or Table Showing Previous Week Tickets vs Current Week
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.
Good Day!
This is the link for you to download the sample data PBI file.
https://1drv.ms/f/s!AsN51lqO15IAgZV_XWkFsZyJ4EOH-w?e=l9BBb8
Thanks again for all the help!
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.
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
You are welcome.