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...
amitchandak's avatar
amitchandak
Super User
6 years ago

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'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
    Community 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.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      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's avatar
        Icey
        Community Support
        6 years ago

        Hi Anonymous ,

         

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

         

         

        Best Regards,

        Icey

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      I give you the test pbix
      pbix


      • Icey's avatar
        Icey
        Community Support
        6 years ago

        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.