Total Sales Last week Calculation DAX - Non Standard date

The easiest way to tackle this is to add a new column to your date table that evaluates to either “Current Week”, “Last Week” based on the date or the relative week (as is available in the practice dataset), or blank().

Once you have this, you’ll be able to use a matrix visual. The new calculated column as the columns, and the products as rows. A bit like this, where I’ve used the relative weeks on the columns:

3 Likes