Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
2 years ago
Solved

Verification between dates

Let's imagine that I have the following table: Code cod_int date CT1 seg_client 1/4/2024 CT1 seg_client 3/6/2024 CT1 seg_client 18/6/2024 CT2 seg_client 3/3/2024 I...
  • Anonymous's avatar
    Anonymous
    2 years ago

    Thanks for the reply from amitchandak , please allow me to provide another insight: 


    Hi  Syndicate_Admin ,

    Here are the steps you can follow:

    1. Create measure.

    Measure =
    var _column=
    SELECTCOLUMNS(
        FILTER(ALL('MovInteracciones_sql'),
        'MovInteracciones_sql'[date]>=DATE(2024,6,1) && 'MovInteracciones_sql'[date]<=DATE(2024,6,15)&&'MovInteracciones_sql'[cod_int]="seg_client"),"test",[Code])
    return
    CALCULATE(
        COUNTROWS(
            'MovInteracciones_sql'),
            FILTER('MovInteracciones_sql',
            NOT('MovInteracciones_sql'[Code]) in _column)
    )

    2. Result:

     

     

    Best Regards,

    Liu Yang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly