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
Nithinprakash
New Member

Get Previous year data for weekly data with multiple categories

As the subject mentions I have weekly sales data for last 3 years, that are split on multiple categories like country, Segments, Devices, entitlement status and marketing channel. I do not have daily data. So, my date metrics are fiscal_year (yyyy), qtr(Q#) and Week(ww) all are in text format and weeks are of 01, 02  and not 1,2.

My need is to create a column to get previous year's data in a new column.

3 REPLIES 3
Nithinprakash
New Member

I have 21 segments and 3 years worth data.. fw is week

Nithinprakash_0-1669736800955.png

 

FreemanZ
Super User
Super User

can you share some sample data?

Desktop20201Segment1OrganicANZQ1781
Desktop20201Segment1OrganicCHNQ13
Desktop20201Segment1OrganicHKTQ1330
Desktop20201Segment1OrganicINQ1387
Desktop20201Segment1OrganicKORQ1319
Desktop20201Segment1OrganicSEAQ1285
Desktop20201Segment1Paid MediaANZQ1683
Desktop20201Segment1Paid MediaCHNQ12
Desktop20201Segment1Paid MediaHKTQ1133
Desktop20201Segment1Paid MediaINQ1148
Desktop20201Segment1Paid MediaKORQ1238
Desktop20201Segment1Paid MediaSEAQ1138
Desktop20201Segment1ProductANZQ12162
Desktop20201Segment1ProductCHNQ115
Desktop20201Segment1ProductHKTQ1479
Desktop20201Segment1ProductINQ1339
Desktop20201Segment1ProductKORQ1935
Desktop20201Segment1ProductSEAQ1342
Desktop20201Segment1UnknownANZQ119
Desktop20201Segment1UnknownCHNQ10
Desktop20201Segment1UnknownHKTQ18
Desktop20201Segment1UnknownINQ114
Desktop20201Segment1UnknownKORQ112
Desktop20201Segment1UnknownSEAQ17
Desktop20201Segment2OrganicANZQ12888
Desktop20201Segment2OrganicCHNQ1239
Desktop20201Segment2OrganicHKTQ1985

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