Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

LTM in column

Good I have a little doubt I would want to transform a measure into a calculated column but it does not give me the expected values: Total acumulado de Horas Curso en ID_PERIODO = CALCULA...
Anonymous's avatar
Anonymous
Not applicable
6 years ago

I know my measurement is fine, I put the photograph to be observed. I want that measure turned into a column

Icey's avatar
Icey
Icon for Community Support rankCommunity Support
6 years ago

Hi Anonymous ,

 

Try this:

Columna =
CALCULATE (
    SUM ( 'FORMACION'[Horas Curso] );
    FILTER (
        ALLSELECTED ( 'Maestra Fechas'[FECHA] );
        'Maestra Fechas'[FECHA]
            IN DATESINPERIOD (
                'Maestra Fechas'[FECHA_PERI];
                'Maestra Fechas'[FECHA];
                -12;
                MONTH
            )
    )
)

 

If it doesn't work, please share me a dummy pbix file for test, only with necessary part, removing sensitive information and replacing real data with dummy data. It is suggested to upload your file to OneDrive for Business and then paste the link here.

 

 

Best Regards,

Icey

 

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