Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Relative Date Based on Slice Selected

Hi, My model has two table, one for the calendar and other for data. I have a date slice and a matrix with month/year columns. I would like to show the last 3 months as column based on slice select...
  • Anonymous's avatar
    Anonymous
    6 years ago

    I solved my problem with the following measure with some adjustment to deal with year/month. But the idea is to use an agregate function considering all dates from calendar that is inside a range (GENERATESERIES).

     

    _TotalProduct = 
CALCULATE(
    SUM(Data[product]); 
    FILTER(
        ALL(Calendar); 
        Calendar[Year] IN GENERATESERIES(SELECTEDVALUE(Calendar[Year])-3; SELECTEDVALUE(Calendar[Year]);1)
    )
)

     

     

     

     

     

     

     

     

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

I solved my problem with the following measure with some adjustment to deal with year/month. But the idea is to use an agregate function considering all dates from calendar that is inside a range (GENERATESERIES).

 

_TotalProduct = 
CALCULATE(
    SUM(Data[product]); 
    FILTER(
        ALL(Calendar); 
        Calendar[Year] IN GENERATESERIES(SELECTEDVALUE(Calendar[Year])-3; SELECTEDVALUE(Calendar[Year]);1)
    )
)