Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
4 years ago
Solved

Consecutive count and sum

Buen Dia I need your help to be able to generate a calculated column that will tell me and add if it meets the conditions of the IF.
To be a little more specific I need to be counted and adding the amount of quotas that the sentences comply with

from now thank you very much

  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Syndicate_Admin ,

     

    Please create these two calculated columns.

    Condition = 
VAR _condition =
    IF (
        AND (
            'DATASET_CAIDA_PRESELECION'[FECHA_VENCIMIENTO] >= 'DATASET_CAIDA_PRESELECION'[FECHA A CEDER],
            'DATASET_CAIDA_PRESELECION'[NROCUOTA] <= 'DATASET_CAIDA_PRESELECION'[CuotaMax]
        ),
        "MEET"
    )
RETURN
    _condition
    Consecutive times = 
VAR _date =
    CALCULATE (
        MAX ( 'DATASET_CAIDA_PRESELECION'[FECHA_VENCIMIENTO] ),
        FILTER (
            ALL ( 'DATASET_CAIDA_PRESELECION' ),
            'DATASET_CAIDA_PRESELECION'[Condition] <> "MEET"
                && 'DATASET_CAIDA_PRESELECION'[FECHA_VENCIMIENTO]
                    <= EARLIER ( 'DATASET_CAIDA_PRESELECION'[FECHA_VENCIMIENTO] )
                && 'DATASET_CAIDA_PRESELECION'[ID_CREDITO]
                    = EARLIER ( 'DATASET_CAIDA_PRESELECION'[ID_CREDITO] )
        )
    )
VAR _times =
    CALCULATE (
        COUNTROWS ( 'DATASET_CAIDA_PRESELECION' ),
        FILTER (
            ALL ( 'DATASET_CAIDA_PRESELECION' ),
            'DATASET_CAIDA_PRESELECION'[FECHA_VENCIMIENTO]
                <= EARLIER ( 'DATASET_CAIDA_PRESELECION'[FECHA_VENCIMIENTO] )
                && 'DATASET_CAIDA_PRESELECION'[FECHA_VENCIMIENTO] > _date
                && 'DATASET_CAIDA_PRESELECION'[ID_CREDITO]
                    = EARLIER ( 'DATASET_CAIDA_PRESELECION'[ID_CREDITO] )
        )
    ) + 0
RETURN
    _times

    Best Regards,
    Gao
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly -- How to provide sample data

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Syndicate_Admin ,

     

    Please create these two calculated columns.

    Condition = 
VAR _condition =
    IF (
        AND (
            'DATASET_CAIDA_PRESELECION'[FECHA_VENCIMIENTO] >= 'DATASET_CAIDA_PRESELECION'[FECHA A CEDER],
            'DATASET_CAIDA_PRESELECION'[NROCUOTA] <= 'DATASET_CAIDA_PRESELECION'[CuotaMax]
        ),
        "MEET"
    )
RETURN
    _condition
    Consecutive times = 
VAR _date =
    CALCULATE (
        MAX ( 'DATASET_CAIDA_PRESELECION'[FECHA_VENCIMIENTO] ),
        FILTER (
            ALL ( 'DATASET_CAIDA_PRESELECION' ),
            'DATASET_CAIDA_PRESELECION'[Condition] <> "MEET"
                && 'DATASET_CAIDA_PRESELECION'[FECHA_VENCIMIENTO]
                    <= EARLIER ( 'DATASET_CAIDA_PRESELECION'[FECHA_VENCIMIENTO] )
                && 'DATASET_CAIDA_PRESELECION'[ID_CREDITO]
                    = EARLIER ( 'DATASET_CAIDA_PRESELECION'[ID_CREDITO] )
        )
    )
VAR _times =
    CALCULATE (
        COUNTROWS ( 'DATASET_CAIDA_PRESELECION' ),
        FILTER (
            ALL ( 'DATASET_CAIDA_PRESELECION' ),
            'DATASET_CAIDA_PRESELECION'[FECHA_VENCIMIENTO]
                <= EARLIER ( 'DATASET_CAIDA_PRESELECION'[FECHA_VENCIMIENTO] )
                && 'DATASET_CAIDA_PRESELECION'[FECHA_VENCIMIENTO] > _date
                && 'DATASET_CAIDA_PRESELECION'[ID_CREDITO]
                    = EARLIER ( 'DATASET_CAIDA_PRESELECION'[ID_CREDITO] )
        )
    ) + 0
RETURN
    _times

    Best Regards,
    Gao
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly -- How to provide sample data