Forum Discussion

multt0's avatar
multt0
Frequent Visitor
3 years ago
Solved

Calculate MAT with Date filter

I made MAT measure like below   mat = CALCULATE(SUM('Fct_Sales_IMS'[Values_LC]),                DATESINPERIOD( 'CALENDAR'[Date], MAX('CALENDAR'[Date]), -12, MONTH))     1) I want to ano...
Need Help
  • FreemanZ's avatar
    FreemanZ
    3 years ago

    Hi   multt0 

    try to create the measure with this (the VAR part seems unnecessary):

    MAT_y-1 = 
CALCULATE(
    SUM('Fct_Sales_IMS'[Values_LC]),
    SAMEPERIODLASTYEAR(DATESINPERIOD('CALENDAR'[Date], MAX('CALENDAR'[Date]), -12, MONTH))
)

     

FreemanZ's avatar
FreemanZ
Super User
3 years ago

Hi   multt0 

try to create the measure with this (the VAR part seems unnecessary):

MAT_y-1 = 
CALCULATE(
    SUM('Fct_Sales_IMS'[Values_LC]),
    SAMEPERIODLASTYEAR(DATESINPERIOD('CALENDAR'[Date], MAX('CALENDAR'[Date]), -12, MONTH))
)

 

multt0's avatar
multt0
Frequent Visitor
3 years ago

It is working,
i can't find prev quater funtion like "SAMEPERIODLASTYEAR"

  • FreemanZ's avatar
    FreemanZ
    Super User
    3 years ago

    there is no such function😂, try to use DATEADD. It is more flexible. Most Time Intelligence functions return a list of dates, so be brave to nest them.