Prev 2 Qtrs and Prev 4 Qtrs

[Anonymous]

Hello,

I need assistance figuring out what formula to use to obtain the previous 2 and 4 Qtrs in sales. I am using a table listing products and to the right i have two columns, Prev 2 Qtrs and Prev 4 Qtrs.  The data has to reference todays date and I'm not looking for QTD or use slicers.

Thank you in advance.

[harshnathani · Accepted solution]

Hi @Anonymous ,

Please see , if this helps.

https://community.powerbi.com/t5/Desktop/How-to-display-last-5-quarters-based-on-current-date/td-p/594837

https://community.powerbi.com/t5/Desktop/Last-x-number-of-quarters/td-p/360642

Regards,
Harsh Nathani

Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)