Retrieving previous period values in Power BI is a common task, but retrieving previous week values requires some special attention. In this video, Brian discusses two straightforward and versatile methods for obtaining previous week values that can be useful additions to your toolbox, one using DAX and another one using Power Query.

***** Video Details *****
00:00 Introduction
01:10 Max Week #
02:30 DATEADD
02:58 Offsets
05:30 Previous Week #
10:47 Imke Feldmann technique
12:28 Group By
13:34 Merge

***** Related Links *****
Extended Date Table Power Query M Function Tutorial – https://youtu.be/-C3_P-jJo4U
Imke Feldmann Blog Entry – https://www.thebiccountant.com/2018/07/12/fast-and-easy-way-to-reference-previous-or-next-rows-in-power-query-or-power-bi/

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi
FREE COURSE – Ultimate Beginners Guide To DAX – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-dax
FREE – Power BI Resources – http://enterprisedna.co/power-bi-resources
FREE – 60 Page DAX Reference Guide Download – https://enterprisedna.co/dax-formula-reference-guide-download/
Enterprise DNA Membership – https://enterprisedna.co/membership
Enterprise DNA Online – http://portal.enterprisedna.co/
Enterprise DNA Events – https://enterprisedna.co/enterprise-dna-events-page/

#EnterpriseDNA #PowerBI #PowerBIDesktop #PowerBITutorial #DAX #DAXTutorial #PowerQuery #PowerQueryTutorial