Forum Discussion
Show items that are not duplicates
I am reviewing negative inventory transactions. I am viewing inventory as a snap shot every Friday. From week to week we have normally the same items in a "negative" status. I want to be able to view what are new occurances that have not be negative in the prior weeks reports. So I can easily remove the duplicates in the query editor but I want to be able to filter between what has reoccured from week to week and what is new.
5 Replies
- parry2k
Super User
Anonymous can you share sample data and expected output. Read this post to get your answer quickly.
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490 - amitchandak
Anonymous , Not very clear, Check if These Week vs Week can help
https://medium.com/@amitchandak.1978/power-bi-wtd-questions-time-intelligence-4-5-98c30fab69d3
https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-Last-Week/ba-p/1051123 amitchandak parry2k Understood, sorry about that. My fault.. Please see below.. Every week (Report run date) I look at inventory that is negative. Reoccuring negatives from week to week are already addressed the first week they go negative. I wan to see items that are fresh occurances.. As you can see below, item 1939812 just went negative last week. It would be a negative that I need to diagnoise. Every other item below has already been addressed. I want a table matrix that would only show 1939812 because it has never been recorded negative in a prior report date..
Make sense?
Date Report Ran Item Description Inventory Level 8/7/2020 1939812 IBEAM AL 15"x465"(38'9") 39271 -2 First Occurance << I want to only see items that are new occurances. See the Date. 8/7/2020 1939815 IN DL TUBE,3.1SQx.375x29.5" W/FOOT,19262 -20.24 Duplicate 7/31/2020 1939815 IN DL TUBE,3.1SQx.375x29.5" W/FOOT,19262 -16.24 Duplicate 7/24/2020 1939833 RUB RAIL WAVE (1-PC)x486"35423 -1 Duplicate 7/31/2020 1939833 RUB RAIL WAVE (1-PC)x486"35423 -1 Duplicate 8/7/2020 1939833 RUB RAIL WAVE (1-PC)x486"35423 -1 Duplicate 7/24/2020 1939885 ALUMINUM INNER LEG ONLY -1 Duplicate 7/31/2020 1939885 ALUMINUM INNER LEG ONLY -1 Duplicate 8/7/2020 1939885 ALUMINUM INNER LEG ONLY -1 Duplicate 7/24/2020 2000849 ALUMINUM OUTER LEG ONLY -4 Duplicate 7/31/2020 2000849 ALUMINUM OUTER LEG ONLY -4 Duplicate 8/7/2020 2000849 ALUMINUM OUTER LEG ONLY -4 Duplicate
