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
nimp_kp
Frequent Visitor

Matrix with dynamic columns of the last 3 years

Hi

 

I'm trying to create a matrix table that shows the sales at two specific dates each year for the last 3 years.

The specific dates are february 1st and july 1st.

As of today, the table should have 7 date columns: july 1st 2016, february 1st 2017....july 1st 2019. 

I want the table to show every sales date in between the newest sales date and 3 years back. As of today that is july 1st 2016 to july 1st 2019.

When we get to february 1st 2020 the measure should dynamically change the columns so the newest sales date is february 1st 2020 and the oldest is february 1st 2017.

Something like this:

 

What the table should show today:

 20160701201702012017070120180201201807012019020120190701
sales1000100020002000100015001200

 

What the table should show when we reach february 1st 2020:

 20170201201707012018020120180701201902012019070120200201
sales1000200020001000150012002000

Thanks

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.

Top Solution Authors