Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Anonymous
Not applicable

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.

 

JClaborn_0-1597158458013.png

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

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

View solution in original post

5 REPLIES 5
Anonymous
Not applicable

@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 RanItemDescriptionInventory Level          
8/7/20201939812IBEAM AL 15"x465"(38'9") 39271-2 First Occurance<< I want to only see items that are new occurances. See the Date.
8/7/20201939815IN DL TUBE,3.1SQx.375x29.5" W/FOOT,19262-20.24 Duplicate        
7/31/20201939815IN DL TUBE,3.1SQx.375x29.5" W/FOOT,19262-16.24 Duplicate        
7/24/20201939833RUB RAIL WAVE (1-PC)x486"35423-1 Duplicate        
7/31/20201939833RUB RAIL WAVE (1-PC)x486"35423-1 Duplicate        
8/7/20201939833RUB RAIL WAVE (1-PC)x486"35423-1 Duplicate        
7/24/20201939885ALUMINUM INNER LEG ONLY-1 Duplicate        
7/31/20201939885ALUMINUM INNER LEG ONLY-1 Duplicate        
8/7/20201939885ALUMINUM INNER LEG ONLY-1 Duplicate        
7/24/20202000849ALUMINUM OUTER LEG ONLY-4 Duplicate        
7/31/20202000849ALUMINUM OUTER LEG ONLY-4 Duplicate        
8/7/20202000849ALUMINUM OUTER LEG ONLY-4 Duplicate        
Anonymous
Not applicable

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

 

@amitchandak @parry2k 

Anonymous
Not applicable

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

amitchandak
Super User
Super User

@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

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
parry2k
Super User
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



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.