Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Aasish
Frequent Visitor

Need help to show previous 6-Week data from the given date in the reports in Matrix Chart

Hi,

 

I have a table which has below fields:

1. ID

2.BU

3.Orgin Area

4.Destination Area

5.Start Date

6.End Date

7.Total Orders

8.Total Commitments

9.Week End Date

 

I need to filter the report to show previous 6-week ends based on the date slected. For Eg: If the Date Selected is 2017/11/8 then it should show the data of previous 6-week ends(WeekEnding Date) as  2017/11/04,2017/10/28,2017/10/21,2017/10/14,2017/10/07,2017/09/30.

 

Note: I have calculated total commitments and order and derived the weekend in SQL query itself. But i just want to filter the weekend column to prev 6 weekend in the report based on the user input date and show the data as below:

Capture.PNGCan anyone please help me on this ?

0 REPLIES 0

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.