Forum Discussion

srhoag's avatar
srhoag
Regular Visitor
9 years ago

Find most current date an item was cycle counted...

Sorry for this exceedingly basic question, but I am trying to report cycle count data for our auditors.   They only want to see the most recent cycle count on each item.   So how do I tell PowerBI to...
v-sihou-msft's avatar
v-sihou-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

srhoag

 

In this scenario, you just need to limit the context into max date rows.

 

Measure 3 = CALCULATE(SUM(Table4[Phyiscal Count]),FILTER(Table4,Table4[Date]=MAX(Table4[Date])))

 

 

Regards,

srhoag's avatar
srhoag
Regular Visitor
9 years ago

Here is what I got when I tried that code snippet:

 

After Item 11908 it appeared to show the later date as 2.00 and the earlier as 1.00.   Prior to 11908, it just shows 1.00 in the Measure 3 column no matter if there are mulitple entries or not.

 

I am so confused.  :-/