Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe 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.
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.
Solved! Go to Solution.
I did a countif on my source data, only to show items that were listed once. Problem solved.
@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 |
I did a countif on my source data, only to show items that were listed once. Problem solved.
@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
@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.
User | Count |
---|---|
120 | |
65 | |
62 | |
56 | |
50 |
User | Count |
---|---|
181 | |
85 | |
67 | |
62 | |
55 |