MTD, QTD and YTD Drill through to table not passing date

[Anonymous]

Hi i have created a table that calculates the sum of invoices for this year and last year MTD, QTD and YTD values. this table works fine., i use the measures

MTD = TOTALMTD(SUM(H15[Rev (£)]), CalendarKey[Date])

MTD LY = CALCULATE([MTD], DATEADD(LASTDATE(CalendarKey[Date]), -1, YEAR))

i have created a new tab with a transaction table and added both the MTD and MTD LY measures into the drill through section, however when i drill through it is only passing through the Manufacturer field and NOT the time period, so i end up with 5 years worth of data, instead of the MTD or MTD LY only transactions.

i am a bit stuck with this if you can help?

[v-piga-msft]

Hi @Anonymous ,

Have you solved your problem?

If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

If you still need help, please feel free to ask.

Best Regards,

Cherry

[rajulshah]

Hello @Anonymous ,

Were you able to solve your issue? I am facing the same issue.

Any help would be great.

Thanks in advance.

[v-piga-msft]

Hi @Anonymous ,

To understand your scenario better, please share some data sample and your desired output so that we could help further on it.

Please refer to how to get your question answered quickly.

Best  Regards,

Cherry