cancel
Showing results for 
Search instead for 
Did you mean: 
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
Community Champion
Community Champion

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
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Top Solution Authors
Top Kudoed Authors