Forum Discussion

wooand's avatar
wooand
Helper II
8 years ago
Solved

Prior Month Summaries.

I need to produce a summary of various stats for different one month periods, for example, last month, two months ago and so on.  I have used this code:   1m Ago Volume = CALCULATE(SUM('Results'[US...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    Hi wooand

     

    Give this a shot

     

    1m Ago Volume =
CALCULATE (
    SUM ( Results[USD Amount] ),
    DATESINPERIOD (
        Results[Trade Date],
        SELECTEDVALUE ( Results[Trade Date] ),
        -2,
        MONTH
    )
)

     or

     

    1m Ago Volume =
CALCULATE (
    SUM ( Results[USD Amount] ),
    DATESINPERIOD ( Results[Trade Date], TODAY (), -2, MONTH )
)
Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
8 years ago

Hi wooand

 

Give this a shot

 

1m Ago Volume =
CALCULATE (
    SUM ( Results[USD Amount] ),
    DATESINPERIOD (
        Results[Trade Date],
        SELECTEDVALUE ( Results[Trade Date] ),
        -2,
        MONTH
    )
)

 or

 

1m Ago Volume =
CALCULATE (
    SUM ( Results[USD Amount] ),
    DATESINPERIOD ( Results[Trade Date], TODAY (), -2, MONTH )
)