Forum Discussion
Solved
IP Address Compare and Categorize
Hello, I'm hoping to get some help with this. I've tried a few things but haven't been able to get exactly what I need. Apologies if there's an easy solution to this, I'm still learning how to us...
My bad I don't see you have IP on 2 columns
old_new = var searchIP = LOOKUPVALUE('Table'[prev],'Table'[prev],'Table'[current]) return IF( searchIP = BLANK(), "new","old")The result
I apologize, would you be able to show me an example with a screenshot? I'm having a hard time understanding. Still pretty new to this! Thank you for your response.
My bad I don't see you have IP on 2 columns
old_new =
var searchIP = LOOKUPVALUE('Table'[prev],'Table'[prev],'Table'[current])
return
IF( searchIP = BLANK(), "new","old")
The result
Awesome! This did exactly what I needed. Thank you so much!
You'r welcome 🙂