Check whether item appears in previous month

[Slavi]

Hello Power BI Community!

I am in need of assitance with a task I'm having trouble with.

I am trying to crate a new calculated column which shows me whether the ID in a particular month has appeared in the previous one, i.e. if the ID is a new one. If the ID is new then the calculated column shoud display 1 if the ID does not appear in the previous month then it should display 0.

I have managed to do it with a measure, but I need to be able to sum-up the end result, i.e. how many new items there are in each month compared to the last one. 

Here is part of the data:

[amitchandak · Accepted solution]

@Slavi , Try a new column like

new column =
var _month = eomonth([month],-1)
var _cnt = countx(filter(table, [ID] = earlier([ID]) && eomonth([month],0) =_max),[ID)
return
if(isblank(_cnt) ,0,1)

[Slavi]

@amitchandak, 
Thank you so much! It works!