Find the sales amount for the previous week using DAX

Hi all,

I’m looking to work out how I can create a table of information the shows the difference between sales for each week on an on-going basis.

Is there any information available from Enterprise DNA around this?

I want to see for every week the change in sales between the previous week.

Thanks for your help.

I’ve created plenty of videos on this topic of dealing with weeks in Power BI.

Check out some of the below.

This can also be compared to dealing with non standard calendars. Unfortunately you can’t use time intelligence functions with these.

It always have to be a combination of CALCULATE and FILTER in some way.

See below for more information around this.

Another good summary article here