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

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
2 years ago

Syndicate_Admin ,

Assuming this counting the client visited # Clientes con visitas fuera de rango

 

Not visited

Countx(Values(MovInteracciones_sql[cod_int]), if (isblank([# Clientes con visitas fuera de rango] ), [cod_int], blank() ))

 

 

Or try like

 

Clientes Sin Visitas en Rango =
VAR DateStart = DATE(2024, 6, 1)
VAR DateEnd = DATE(2024, 6, 15)

RETURN
CALCULATE(COUNTROWS(DISTINCT('MovInteracciones_sql'[Code])),
FILTER('MovInteracciones_sql','MovInteracciones_sql'[Interaction Template Code] = "SEG_CLIENT" &&
NOT(CALCULATE(COUNTROWS('MovInteracciones_sql'),'MovInteracciones_sql'[Date] >= DateStart && 'MovInteracciones_sql'[Date] <= DateEnd
) > 0)),'MovInteracciones_sql'[Date] < DateStart || 'MovInteracciones_sql'[Date] > DateEnd)

 

very similar tot lost customer

Customer Retention with Dynamic Segmentation, New/Lost/Retain Customer Count: https://youtu.be/EyL7KMw877Q