Forum Discussion

Junaid11's avatar
Junaid11
Icon for Helper V rankHelper V
4 years ago

Compare text value with previous month

Hello, I want to compare Code which is Text with previous month. Each code can come is unique like in January this code can only comes one not more than that. Same code can come in next month but it...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

Junaid11 , Try like

 

New column =
var _date = [Date]
var _code = maxx(filter(Table,eomonth(_date,0) = eomonth([Date],0) ),[Code])
return
Switch(True(),

[Code] = _code, "Unchanged",

Not(isblank(_code)) && [Code]<> _code, "New" , "Gone")

Junaid11's avatar
Junaid11
Icon for Helper V rankHelper V
4 years ago

Hello amitchandak ,

The code is not working I am getting below outcome which is not similar to outocme I have mentioned.