QTD of prior year

[Anonymous]

Looking to report prior year QTD sales as a measure that will ultimately be used in variance analysis of current QTD versus PYQTD. 

I have an existing measure for current QTD that i'm assuming I would use in the formula?

Pretty novice in the powerbi space, but my co-workers who are much more educated didn't have a good solution, so hopefully someone here can help! 

Thanks,!

[Ashish_Mathur · Accepted solution]

Hi,

Try this measure

=CALCULATE(SUM(Data[Sales]),SAMEPERIODLASTYEAR(Calendar[Date]))

There should be a Calendar Table and a relationship from the Date column of the Data Table to the Date column of the Calendar Table.  In the Calendar Table, extract Year and Quarter via calculated column formulas.  In your visual, drag Year and Quarter from the Calendar Table.