Forum Discussion
SameperoidLastYear Drillthrough
Hi Anonymous ,
Not very clear, better to share some sample data with screenshot and the expected result to us.
Best Regards,
Jay
Hi Below the sample data. Whit this data I was able to calculate count of Order IDs by current rolling 12 months and SamePeriodLastYear (using SamePeriodLasyYear Dax). I used Combo chart to populate both segments (Bar being rolling 12 months and line being SamePeriodLasyYear). Client wanted to look at the detailed records where in if we click on current months bar then he must see the current month Order IDs. I created drilll through for all detailed order ids.
Drill through always passing month (respect to Bar) to detailed page I am good there, however when I click on the Line it still Passing month assiciated to Bar not the line.
For example if I clicek on June 2021 bar drill through showing detailed records with respect to June 2021 and If try to drillthrough on respective SamePeriodLastYear line drillthrough supposed to pass June 2020 but it still taking June 20210 as data filter. Hope I provided detailed explanation, please help me out how to get this resolved.
Sincerely,
Vamsikrishna.
| Order ID | Order Date | Category |
| CA-2017-126221 | 12/30/2021 | Ship Mode |
| CA-2017-143259 | 12/30/2021 | Standard Class |
| CA-2017-119305 | 11/30/2021 | First Class |
| CA-2017-116645 | 11/30/2021 | Second Class |
| CA-2017-104136 | 11/1/2021 | Same Day |
| CA-2017-104136 | 11/1/2021 | Ship Mode |
| CA-2017-131632 | 10/31/2021 | Standard Class |
| CA-2017-117114 | 10/31/2021 | First Class |
| CA-2017-117114 | 10/31/2021 | Second Class |
| CA-2017-128041 | 9/1/2021 | Same Day |
| CA-2017-128041 | 9/1/2021 | Ship Mode |
| CA-2017-159884 | 8/31/2021 | Standard Class |
| CA-2017-159884 | 8/31/2021 | First Class |
| US-2017-148362 | 7/1/2021 | Second Class |
| US-2017-148362 | 7/1/2021 | Same Day |
| US-2017-148362 | 7/1/2021 | Ship Mode |
| CA-2017-102946 | 6/30/2021 | Standard Class |
| US-2017-102890 | 6/30/2021 | First Class |
| CA-2017-131695 | 6/30/2021 | Second Class |
| CA-2017-110198 | 5/1/2021 | Same Day |
| CA-2017-110198 | 5/1/2021 | Ship Mode |
| CA-2017-151911 | 4/30/2021 | Standard Class |
| CA-2017-144526 | 4/30/2021 | First Class |
| CA-2017-144526 | 4/30/2021 | Second Class |
| CA-2017-155712 | 3/2/2021 | Same Day |
| CA-2017-124114 | 3/2/2021 | Ship Mode |
| CA-2017-101959 | 2/28/2021 | Standard Class |
| CA-2017-101959 | 2/28/2021 | First Class |
| CA-2017-117212 | 2/26/2021 | Second Class |
| CA-2017-151750 | 1/1/2021 | Same Day |
| CA-2017-151750 | 1/1/2021 | Ship Mode |
| CA-2017-160395 | 12/31/2020 | Standard Class |
| CA-2017-160395 | 12/31/2020 | First Class |
| CA-2017-100202 | 12/31/2020 | Second Class |
| CA-2016-100671 | 11/1/2020 | Same Day |
| CA-2016-129196 | 11/1/2020 | Ship Mode |
| CA-2016-119165 | 10/31/2020 | Standard Class |
| CA-2016-144218 | 10/31/2020 | First Class |
| US-2016-142251 | 10/31/2020 | Second Class |
| CA-2016-140130 | 10/31/2020 | Same Day |
| CA-2016-116526 | 9/1/2020 | Ship Mode |
| CA-2016-116526 | 9/1/2020 | Standard Class |
| CA-2016-124583 | 9/1/2020 | First Class |
| CA-2016-117408 | 8/31/2020 | Second Class |
| US-2016-141544 | 8/30/2020 | Same Day |
| US-2016-141544 | 8/30/2020 | Ship Mode |
| US-2016-126431 | 7/1/2020 | Standard Class |
| US-2016-158680 | 7/1/2020 | First Class |
| CA-2016-162355 | 6/30/2020 | Second Class |
| CA-2016-162355 | 6/30/2020 | Same Day |
| CA-2016-135594 | 6/30/2020 | Ship Mode |
| CA-2016-101525 | 5/1/2020 | Standard Class |
| CA-2016-154788 | 4/30/2020 | First Class |
| US-2016-120460 | 4/30/2020 | Second Class |
| US-2016-151862 | 3/1/2020 | Same Day |
| CA-2016-111283 | 2/29/2020 | Ship Mode |
| CA-2016-101623 | 2/28/2020 | Standard Class |
| CA-2016-102456 | 2/27/2020 | First Class |
| CA-2016-101448 | 2/27/2020 | Second Class |
| CA-2016-128706 | 2/27/2020 | Same Day |
| CA-2016-153661 | 1/30/2020 | Ship Mode |
| US-2016-166660 | 1/30/2020 | Standard Class |
| US-2016-166660 | 1/30/2020 | First Class |
| CA-2016-114944 | 1/30/2020 | Second Class |
| CA-2016-168032 | 1/30/2020 | Same Day |
| CA-2015-110814 | 12/5/2019 | Ship Mode |
| CA-2015-110814 | 12/5/2019 | Standard Class |
| CA-2015-149566 | 12/5/2019 | First Class |
| CA-2015-149566 | 12/5/2019 | Second Class |
| CA-2015-141740 | 11/1/2019 | Same Day |
| CA-2015-131457 | 10/31/2019 | Ship Mode |
| CA-2015-122259 | 10/31/2019 | Standard Class |
| CA-2015-162537 | 10/28/2019 | First Class |
| CA-2015-162537 | 10/28/2019 | Second Class |
| CA-2015-162537 | 10/28/2019 | Same Day |
| CA-2015-139290 | 10/26/2019 | Ship Mode |
| CA-2015-156146 | 10/26/2019 | Standard Class |
| CA-2015-156146 | 10/26/2019 | First Class |
| CA-2015-156566 | 10/1/2019 | Second Class |
| CA-2015-169201 | 9/28/2019 | Same Day |
| CA-2015-169201 | 9/28/2019 | Ship Mode |
| CA-2015-104626 | 9/1/2019 | Standard Class |
| CA-2015-104626 | 9/1/2019 | First Class |
| CA-2015-112319 | 8/31/2019 | Second Class |
| CA-2015-111514 | 8/31/2019 | Same Day |
| CA-2015-111514 | 8/31/2019 | Ship Mode |
| CA-2015-153388 | 8/1/2019 | Standard Class |
| CA-2015-153388 | 8/1/2019 | First Class |
| CA-2015-124891 | 7/31/2019 | Second Class |
| CA-2015-124891 | 7/31/2019 | Same Day |
| CA-2015-124891 | 7/31/2019 | Ship Mode |
| CA-2015-128860 | 6/29/2019 | Standard Class |
| US-2015-141684 | 6/29/2019 | First Class |
| CA-2015-165799 | 6/29/2019 | Second Class |
| US-2015-100069 | 6/29/2019 | Same Day |
| CA-2015-124919 | 5/31/2019 | Ship Mode |
| CA-2015-124919 | 5/31/2019 | Standard Class |
| CA-2015-124919 | 5/31/2019 | First Class |
| CA-2015-100818 | 5/31/2019 | Second Class |
| CA-2015-100818 | 5/31/2019 | Same Day |
| CA-2015-104486 | 5/1/2019 | Ship Mode |
| CA-2015-104486 | 5/1/2019 | Standard Class |
| US-2015-164175 | 4/30/2019 | First Class |
| CA-2015-135174 | 4/30/2019 | Second Class |
| CA-2015-103716 | 4/30/2019 | Same Day |
| CA-2015-103716 | 4/30/2019 | Ship Mode |
| CA-2015-128125 | 3/31/2019 | Standard Class |
| CA-2015-133494 | 3/1/2019 | First Class |
| CA-2015-133585 | 3/1/2019 | Second Class |
| CA-2015-133585 | 3/1/2019 | Same Day |
| CA-2015-104052 | 3/1/2019 | Same Day |