Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Previous month calculation

Hi Community,   I need to set a Column with a 1 or 0 if a value in a column is new in the Current Month (1) or if it is the same in previous month (0).  How can I do that?  I have tried many ways b...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    5 years ago

    Anonymous 

    you can create a column

    Column = if(ISBLANK(maxx(FILTER('Table','Table'[Agreement]=EARLIER('Table'[Agreement])&&'Table'[Month]<EARLIER('Table'[Month])),'Table'[Month])),1,0)

Ashish_Mathur's avatar
Ashish_Mathur
Super User
5 years ago

Hi,

This calculated column formula works

=if(ISNUMBER(CALCULATE(COUNTROWS(Data_2),FILTER(Data_2,Data_2[Agreement]=EARLIER(Data_2[Agreement])&&Data_2[Month]<EARLIER(Data_2[Month])))),0,1)

Hope this helps.