Can I get the dynamic data related to dynamic measure in power bi

[AnilKumar]

Hi,

I have the data in a table as shown below,

max qty of item is a measure 

MAx Qty of Item = CALCULATE(MAXX(SUMMARIZE('All Transactions','All Transactions'[Posting Date],"MAXX",SUM('All Transactions'[CLosing])),[MAXX]),ALL('All Transactions'[Posting Date]))

So, in another table I need to get that item no , max Qty of item and its related date .

But Iam not getting the date.

For example , from the above data in table I have get data Like,

Item no                       Max Qty           Posting date 

BOICHAR00031            8                          27-11-2018

But Iam missing at that date. Please suggest how to do ?

Regards,

Susmitha.

[v-qiuyu-msft]

Hi @AnilKumar, 

Please share a pbix file with us, do remove sensitive data in the report before sharing. 

Best Regards,
Qiuyun Yu 

[AnilKumar]

Hi,

My report is like this

In image ,

When I change the date, Data shown in 2 will be changed. Max consumed qty will be shown as max qty for that particular item no. But for that particular qty I want to return that particular date.

But when I drag date field it is getting all dates like shown in 3.

So this is my issue.

Iam also attaching the pbix file using google drive link.

https://drive.google.com/open?id=1doE1yCoRAqd1LeYbsqYV0_hDBieH4tgL

Reagards,

Susmitha.