Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
3 years ago
Solved

Validate correlation

I have a table where there is the column containing the registration number and I want to add two new columns where one tells me if there was a numbering break and another that tells me how many numbers were skipped. Is it possible to do that?? Thank you very much for the help.

  • amitchandak's avatar
    amitchandak
    3 years ago

    Syndicate_Admin ,

    New columns

     

    Skip =

    var _max = maxx(filter(Table, [registration number] < earlier([registration number]) ),[registration number])

    return

    if(isblank(_max) || [registration number] -Max =1 ,"No", yes)

     

     

     

    Skip number =

    var _max = maxx(filter(Table, [registration number] < earlier([registration number]) ),[registration number])

    return

    if(isblank(_max) || [registration number] -Max =1 ,0, [registration number] -Max )

     

     

    DAX- Earlier, I should have known Earlier: https://youtu.be/CVW6YwvHHi8

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

    Syndicate_Admin ,

    New columns

     

    Skip =

    var _max = maxx(filter(Table, [registration number] < earlier([registration number]) ),[registration number])

    return

    if(isblank(_max) || [registration number] -Max =1 ,"No", yes)

     

     

     

    Skip number =

    var _max = maxx(filter(Table, [registration number] < earlier([registration number]) ),[registration number])

    return

    if(isblank(_max) || [registration number] -Max =1 ,0, [registration number] -Max )

     

     

    DAX- Earlier, I should have known Earlier: https://youtu.be/CVW6YwvHHi8