Incorect values YTD and PREVIOUSMONTH when applying SELECTCOLUMNS

[gerardotrejogcg]

Looks like row context is working when applying SELECTCOLUMNS.  Expected values are placed in the full table 2022

This is the DAX sintax of above one row table - that is wrong.   I'm using SELECTCOLUMNS because I need to UNION similar calculations with other variables.

Monthly Scorecard =

SELECTCOLUMNS (

    'Ruta Corta',

    "ID", 1,

    "Fecha", 'Ruta Corta'[Fecha Ruta],

    "L1", "VOLUME",

    "L2", "Production",

    "UoM", "Lts/Day",

    "Target", "140,000",

    "YTD", TOTALYTD ( [Lts Average] , Fecha[Fecha] ), --[Lts Average YTD],

    "M-2",

        CALCULATE (

            [Lts Average],

            PREVIOUSMONTH ( PREVIOUSMONTH ( 'Ruta Corta'[Fecha Ruta] ) )

        ),

    "M-1",

        CALCULATE (

            [Lts Average],

            PREVIOUSMONTH ( 'Ruta Corta'[Fecha Ruta] )

        ),

    "M", [Lts Average]

)

[amitchandak]

@gerardotrejogcg , If you are creating a table, this will not take slicer values.

PREVIOUSMONTH works on first date available in the calendar 

datesytd (datesqtd, datesmtd, totalytd) use the last available date in the calendar. That will give you your results

If the table is used as a var in the measure it can work

Why previousmonth does not give result when datesmtd is giving it: https://youtu.be/1KkoJehRVeg