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.
Share the download link of the PBI file.
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.