Forum Discussion

Kurt4597's avatar
Kurt4597
Helper I
3 years ago
Solved

Previous Month Filtering

Hello All,   I have been stuck on this issue for a few hours and really can't seem to fix it. Any help would be greatly appreciated.  DateDim Table     Deals Table     I have a...
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    3 years ago

    Hi,

    Could you please try something like below and please check whether it suits your requirement?

     

    Average Cost Last Month =
VAR _prevdate = [PreviousDate]
RETURN
    CALCULATE (
        [Average Cost],
        FILTER ( ALL ( DateDim ), DateDim[YearMonth] = _prevdate )
    )
Jihwan_Kim's avatar
Jihwan_Kim
Super User
3 years ago

Hi,

Could you please try something like below and please check whether it suits your requirement?

 

Average Cost Last Month =
VAR _prevdate = [PreviousDate]
RETURN
    CALCULATE (
        [Average Cost],
        FILTER ( ALL ( DateDim ), DateDim[YearMonth] = _prevdate )
    )
Kurt4597's avatar
Kurt4597
Helper I
3 years ago

Worked great thank you!