Show items that are not duplicates

[Anonymous]

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.

[Anonymous]

@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

[Anonymous]

Simple terms, I want to see duplicates and items that are not duplicates.

@amitchandak @parry2k 

[Anonymous · Accepted solution]

I did a countif on my source data, only to show items that were listed once. Problem solved.

[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

[parry2k]

@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