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...
Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi srhoag

 

Try the following

 

1. Create a measure LastPostingDate = Max (yourtablename[PostingDate])

2. Now plot the [Item Number] and [LastPostingDate] and you will get the desired results.

 

 

If this works for you please accept it as a solution and also give KUDOS.

 

Cheers

 

CheenuSing

 

srhoag's avatar
srhoag
Regular Visitor
9 years ago

Hello CheenuSing,

 

Thank you for the code, but that did not help in this case.  All I got was another column that repeated the Posting Date on each line.

 

What I need the report to do is only show the line with the latest posting date for each item.   Some items are listed muliple times as they have been cycle counted more than once and each cycle count adds a line to the table for that item.

 

 

Maybe the screen shot helps.   I may not have explained the issue clearly in the initial question.

 

Thank you for the response though! - Steve