LTM in column

[Anonymous]

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 = 
CALCULATE(
 SUM('FORMACION'[Horas Curso]);
 FILTER(
  ALLSELECTED('Maestra Fechas'[FECHA]);
  'Maestra Fechas'[FECHA] in DATESINPERIOD('Maestra Fechas'[FECHA_PERI]; MAX('Maestra Fechas'[FECHA]);-12; MONTH
)))

My column is:

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

The result is as follows:

Why don't the same values appear in my column that I should put to make it the same?

[amitchandak]

@Anonymous , your formula seems fine. But it should a measure not column.

Example measures

Rolling 12 = CALCULATE(sum(Sales[Sales Amount]),DATESINPERIOD(Table[Date],ENDOFMONTH(Sales[Sales Date]),-12,MONTH))
Rolling 12 = CALCULATE(sum(Sales[Sales Amount]),DATESINPERIOD(Table[Date Filer],MAX(Sales[Sales Date]),-12,MONTH))

[Anonymous]

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

[Icey]

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.

[Anonymous]

I give you the test pbix
pbix

[Icey]

Hi @Anonymous ,

Why do you want to convert it to column? In your Matrix visual, 'Hoja1'[ID_PERIODO] is one filter context. But in your column, the context is missing. So, the column value is not the same as measure.

Best Regards,

Icey

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

[Anonymous]

I want to convert it to column because of that LTM for this reason because I want to perform that operation, and with a measure does not allow me, so how much I need to perform an LTM on a column and filter

[Anonymous]

para  despues  agruparlo  por el numero que  obtenga  como  resultado:
1-8
9-16
17-32
+32

[Anonymous]

Thank you but that's what's on my post as a measure and it's the same as in the hahaha column. the results are shown in the image.

[Icey]

Hi @Anonymous ,

Well.. It is suggested to share me a dummy pbix file or some dummy data for test.

Best Regards,

Icey