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
With Power Query, create a merge in the same table with IP & DATE criteria
With DAX, create a calculated column to compare the date IP where IP match :
CALCULATE ( MAX ( DATE), filter( TABLE, [IP] = EARLIER([IP]) )
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 🙂