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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.