Forum Discussion
LTM in column
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.
I give you the test pbix
pbix
- Icey6 years ago
Community Support
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.
- Anonymous6 years agoNot applicable
para despues agruparlo por el numero que obtenga como resultado:
1-8
9-16
17-32
+32 - Anonymous6 years agoNot applicable
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