Forum Discussion

Slavi's avatar
Slavi
Frequent Visitor
5 years ago
Solved

Check whether item appears in previous month

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:

Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    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)

2 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    5 years ago

    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)