cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ballist1x
Helper III
Helper III

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

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?
 
3 REPLIES 3
v-piga-msft
Resident Rockstar
Resident Rockstar

Hi @ballist1x ,

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

 

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hello @ballist1x ,

 

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

Any help would be great.

 

Thanks in advance.

v-piga-msft
Resident Rockstar
Resident Rockstar

Hi @ballist1x ,

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

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
User Groups Public Preview

Join us for our User Group Public Preview!

Power BI User Groups are coming! Make sure you’re among the first to know when user groups go live for public preview.

March Update

Check it Out!

Click here to read more about the March 2021 Updates!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.