Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

DAX IDEA

Hi community,   Im trying to find a solution for a measure I created that allows me to have the SUM of the last 5 months from the chosen month in the slicer even if I have more months selected in t...
Need Help
  • christianfcbmx's avatar
    christianfcbmx
    6 years ago

    You need this Anonymous  . ENJOY!!!

     

    XXXX XXXX XXXX =
    SELECTEDVALUE ( 'LLAVE TIPO'[Tipo]; "Negocio" ) = "Negocio";
    CALCULATE (
    SUM('Base Ventas Netas'[Cantidad]);
    'Base Ventas Netas'[Cantidad] <>-1;
    'Base Ventas Netas'[RE/RP]="RPSTD";
    'Base Ventas Netas'[Tabla Pyme] = ">600";ALL('Master Calendar);DATESINPERIOD('Base Ventas Netas'[Mes];MAX('Base Ventas Netas'[Mes]
    );-6;MONTH)
    );
    CALCULATE (
    SUM( 'Base Ventas Netas'[Cantidad] );
    'Base Ventas Netas'[Cantidad] <>-1;
    'Base Ventas Netas'[RE/RP] = "RPSTD";
    'Base Ventas Netas'[ISEE] IN { "ABC1"; "C2" };
    'Base Ventas Netas'[Tabla Persona]
    IN { "<400"; "<600"; "<700"; "<800"; "<900"; ">900" };ALL('Master Calendar;DATESINPERIOD('Base Ventas Netas'[Mes];MAX('Base Ventas Netas'[Mes]
    );-6;MONTH))

     

    + CALCULATE (
    SUM( 'Base Ventas Netas'[Cantidad] );
    'Base Ventas Netas'[ISEE] = "NO DATA";
    'Base Ventas Netas'[Tabla Persona] = ">900";
    'Base Ventas Netas'[Cantidad] <>-1;
    'Base Ventas Netas'[RE/RP] = "RPSTD";ALL('Master Calendar);DATESINPERIOD('Base Ventas Netas'[Mes];MAX('Base Ventas Netas'[Mes]
    );-6;MONTH))
    )
christianfcbmx's avatar
christianfcbmx
Post Patron
6 years ago

You need this Anonymous  . ENJOY!!!

 

XXXX XXXX XXXX =
SELECTEDVALUE ( 'LLAVE TIPO'[Tipo]; "Negocio" ) = "Negocio";
CALCULATE (
SUM('Base Ventas Netas'[Cantidad]);
'Base Ventas Netas'[Cantidad] <>-1;
'Base Ventas Netas'[RE/RP]="RPSTD";
'Base Ventas Netas'[Tabla Pyme] = ">600";ALL('Master Calendar);DATESINPERIOD('Base Ventas Netas'[Mes];MAX('Base Ventas Netas'[Mes]
);-6;MONTH)
);
CALCULATE (
SUM( 'Base Ventas Netas'[Cantidad] );
'Base Ventas Netas'[Cantidad] <>-1;
'Base Ventas Netas'[RE/RP] = "RPSTD";
'Base Ventas Netas'[ISEE] IN { "ABC1"; "C2" };
'Base Ventas Netas'[Tabla Persona]
IN { "<400"; "<600"; "<700"; "<800"; "<900"; ">900" };ALL('Master Calendar;DATESINPERIOD('Base Ventas Netas'[Mes];MAX('Base Ventas Netas'[Mes]
);-6;MONTH))

 

+ CALCULATE (
SUM( 'Base Ventas Netas'[Cantidad] );
'Base Ventas Netas'[ISEE] = "NO DATA";
'Base Ventas Netas'[Tabla Persona] = ">900";
'Base Ventas Netas'[Cantidad] <>-1;
'Base Ventas Netas'[RE/RP] = "RPSTD";ALL('Master Calendar);DATESINPERIOD('Base Ventas Netas'[Mes];MAX('Base Ventas Netas'[Mes]
);-6;MONTH))
)