Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

SSAS tabular cube previous month data

Hi team,   below is my data and yellow color is my expected output. i want to get previous month data. in below "Total" column is my measure and i want to get lag/previous month measure "Previous ...
Need Help
  • v-frfei-msft's avatar
    v-frfei-msft
    6 years ago

    Hi Anonymous ,

     

    Sorry, please update the measure as below.

    Total Previous Month = 
VAR pre =
    EDATE ( MAX('DIM_REVENUE'[date]), -1 )
VAR preym =
    FORMAT ( pre, "mmm yyyy" )
RETURN
    CALCULATE (
        SUM ( DIM_REVENUE[Revenue] ),
        FILTER ( ALLSELECTED(DIM_REVENUE), DIM_REVENUE[Month Name] = preym )
    )

     

    Pbix as attached.

     

  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi v-frfei-msft 

     

    excellent soultion, Thanks a lot for your great help !!!

     

    Regards,

    snkm

v-frfei-msft's avatar
v-frfei-msft
Community Support
6 years ago

Hi Anonymous ,

 

Please try this one please.

Total Previous Month =
VAR pre =
    EDATE ( TODAY (), -1 )
VAR preym =
    FORMAT ( pre, "mmm yyyy" )
RETURN
    CALCULATE (
        SUM ( DIM_REVENUE[Revenue] ),
        FILTER ( DIM_REVENUE, DIM_REVENUE[Month Name] = preym )
    )

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi v-frfei-msft ,

    i have implemented same query given by you and below is the output. i am getting only one month data. would you please suggest any more methods to get all month data.

     

    Regards,

    snkm