Calculate the data related to previous period

[jianlong]

Hi, I am trying to sum up a value for the current periods and the previous periods (current-13).  

I tried this :

case_previous_FP = CALCULATE(SUM(SWT[CASES_COMPLETED]),FILTER(FISCAL_PERIOD,FISCAL_PERIOD[Index]-13))   

Any thoughts?  

btw, date/month/year does not work.  We did generate an index for all the periods..   thanks.

[Ashish_Mathur]

Hi,

Is there no date column?

[CNENFRNL]

Hi, @jianlong , you might want to try this,

case_previous_FP =
CALCULATE ( SUM ( SWT[CASES_COMPLETED] ), FISCAL_PERIOD[Index] <= 13 )

[edhans]

You can try this @jianlong 

case_previous_FP =
CALCULATE(
    SUM( SWT[CASES_COMPLETED] ),
    FILTER(
        ALL( FISCAL_PERIOD[Index] ),
        FISCAL_PERIOD[Index] - 13
    )
)

I'd need to see data though to really look at it more closely.

How to get good help fast. Help us help you.
How to Get Your Question Answered Quickly - Give us a good and concise explanation
How to provide sample data in the Power BI Forum - Provide data in a table format per the link. Provide expected output using a screenshot of Excel or other image. Do not provide a screenshot of the source data. I cannot paste an image into Power BI tables.