Sunday, 5 December 2021

Checking numbers in a string and comparing them to a reference column


Just gotten into DAX and have come across an issue that I can't seem to figure out. I'm trying to make a test to see if the last two numbers in a string are consecutive and if so, if they are within 3 of the reference column, if so, a comment should be added in the output column.Examples:Data columnReference columnOutput columnV5, V12, V13V14TriggeredV13, V14, V15, V17V17Not triggeredV12, V18V19Not triggeredV16Not triggeredV2, V4, V9, V12, V18, V19V19TriggeredV15V15Not triggeredV1, V3, V4, V6V6Not triggeredV6, V8, V14, V15V14TriggeredHope you can help

No comments:

Post a Comment