previous quarter to date

Hi Anonymous,

First of all the measure you have for QTD is not calculation QTD you should use one of two formulas:

Current QTD = Calculate(TOTALQTD(SUM(Table2[Value]);DIM_Date[Date]) )

Current QTD = Calculate(SUM(Table2[Value]);DATESQTD(DIM_Date[Date]) )

Regarding the previous QTD when you use the DATEADD you will get all the all the dates that are in the time frame you have for this case you need to calculate the number of days that have pass over previous quarter and calculate the total for those number of days.

Try this measure:

Measure =
VAR Previous_Quarter =
    STARTOFQUARTER ( DATEADD ( DIM_Date[Date]; -1; QUARTER ) )
VAR Previous_Quarter_end =
    ENDOFQUARTER ( DATEADD ( DIM_Date[Date]; -1; QUARTER ) )
VAR Current_Quarter_Start =
    STARTOFQUARTER ( DIM_Date[Date] )
VAR Max_Date =
    MAX ( Table2[Date] )
RETURN
    CALCULATE (
        SUM ( Table2[Value] );
        DIM_Date[Date] >= Previous_Quarter
            && DIM_Date[Date]
                <= IF (
                    Previous_Quarter_end
                        <= Previous_Quarter + DATEDIFF ( Current_Quarter_Start; Max_Date; DAY );
                    Previous_Quarter_end;
                    Previous_Quarter + DATEDIFF ( Current_Quarter_Start; Max_Date; DAY )
                )
    )

This will give you the below result (for my values I have 100 for Q1, 200 Q2, 300 Q3, 400 Q4) as you can see previous quarte is half the value in the quarter.

I also added the PBIX attach so you can play around with the slicer

Regards

MFelix