Nested IF statement in custom column

Hi gianmarco ,

Please try code as below.

Column =

VAR SUPPLIERS =
    CALCULATE (
        SUM ( Cashflow[Importo (+/-)] ),
        FILTER ( Cashflow, Cashflow[Source] = 0 && Cashflow[Categoria] = "FORNITORI" )
    )
VAR PREVISIONE_FORNITORI_CURRENT = Cashflow[Source] = 5
    && Cashflow[Completed_month] = 0
    && Cashflow[Par1] = 1
VAR CLIENTS =
    CALCULATE (
        SUM ( Cashflow[Importo (+/-)] ),
        FILTER ( Cashflow, Cashflow[Source] = 0 && Cashflow[Categoria] = "CLIENTI" )
    )
VAR PREVISIONE_CLIENTI_CURRENT = Cashflow[Source] = 5
    && Cashflow[Completed_month] = 0
    && Cashflow[Par1] = 0
VAR PREVISIONALE_PAST = Cashflow[Source] = 5
    && Cashflow[Completed_month] = 1
RETURN
    IF (
        PREVISIONALE_PAST,
        0,
        IF (
            PREVISIONE_FORNITORI_CURRENT,
            Cashflow[Importo (+/-)] - ( SUPPLIERS ),
            IF (
                PREVISIONE_CLIENTI_CURRENT,
                Cashflow[Importo (+/-)] - ( CLIENTS ),
                Cashflow[Importo (+/-)]
            )
        )
    )

Best Regards,
Rico Zhou

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