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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
esthony
Frequent Visitor

List down the items that exist from the previous month but not in Current Month

Hi,

 

Good day. Need help on power bi desktop. I was able to create a measure that will count the number of lots that exist from the previous but not on the current or succeeding lot. My problem now is how to get the list of those lots.

 

esthony_0-1693799297921.png

I tried to create a measure (below) but i seems not working.

notexist =
var clot = CALCULATETABLE(VALUES(DailyWip[LOT_NUMBER]))
var plot = CALCULATETABLE(VALUES(DailyWip[LOT_NUMBER]),all(DailyWip),PREVIOUSMONTH(DailyWip[Current Date]),DailyWip[on next month] = 0)
return EXCEPT(clot,plot)
 
What is the right approach to solve this? I believe this can be solved without making a separate data table.
 
Thank you.
 
 
Anthony
3 REPLIES 3
Ashish_Mathur
Super User
Super User

Hi,

Share the download link of the PBI file.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
lbendlin
Super User
Super User

so far so good.  What is DailyWip[Current Date] , a column?  Usually you want to use variables to protect your context from the transitions.

Yes Current Date is a column. Im planning to fix this by creating a calendar table and create a inactive relation to the date where it dont exist.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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