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

[esthony]

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.

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

[Ashish_Mathur]

Hi,

Share the download link of the PBI file.

[lbendlin]

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

[esthony]

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.