Forum Discussion
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...
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)
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)Hi Ryan_mayu
Great solution. It solved what we were looking for.
Regards,
Albin