Create table by last 4 weeks

Question

Hi&nbsp;&nbsp;I want to create a report that always shows the last 4 weeks data, grouped by that week.&nbsp;&nbsp;I have been trying to use a matrix table but I don't want the rows to group together.&nbsp; I would like a table like below as my result set.&nbsp; The sales stats come from a different data source than the days worked stats so I would be combining two or more queries.&nbsp;&nbsp;&nbsp;&nbsp;2/12/20232/19/20232/26/20233/5/2023Required Sales500655723800Total sales120555700121Sales Performance24%85%97%15%Days Worked45465547&nbsp;I can set a static visual that the dates are within the last 4 weeks so that next week the dates will change.&nbsp;&nbsp;&nbsp;Any help and guidance much appreciated

anonymous · Accepted Answer

Hi&nbsp;Anonymous&nbsp;,
&nbsp;
I think [Week] column in matrix column field should from a DimWeek table. I suggest you to try to create a measure to filter your visual.
Filter = 
VAR _THISWEEK =
    TODAY () - WEEKDAY ( TODAY () ) + 1
VAR _Last4week = _THISWEEK - 28
RETURN
    IF (
        MAX ( DimWeek[Date] ) &gt;= _Last4week
            &amp;&amp; MAX ( DimWeek[Date] ) &lt; _THISWEEK,
        1,
        0
    )
Add this measure into visual level filter and set it to show items when value = 1. Result is as below.

&nbsp;
Best Regards,Rico Zhou
&nbsp;
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Forum Discussion

Create table by last 4 weeks

1 Reply

Related content

Create new table

Lakehouse Table Generate Create Table

Create rows from 2 tables

Create Week Start date column within a date table

Creating Date Tables

	2/12/2023	2/19/2023	2/26/2023	3/5/2023
Required Sales	500	655	723	800
Total sales	120	555	700	121
Sales Performance	24%	85%	97%	15%
Days Worked	45	46	55	47