cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Reply
Nithinprakash
New Member

Get Previous year data for weekly data with multiple categories

‎11-29-2022 04:41 AM

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.

Message 1 of 4
200 Views
0
3 REPLIES 3
Nithinprakash
New Member

‎11-29-2022 07:46 AM

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

Nithinprakash_0-1669736800955.png

 

Message 4 of 4
177 Views
0
FreemanZ
Community Champion
Community Champion

‎11-29-2022 07:14 AM

can you share some sample data?

Message 2 of 4
187 Views
0
Nithinprakash
New Member
In response to FreemanZ

‎11-30-2022 09:05 PM
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
Message 3 of 4
140 Views
0

Helpful resources

Announcements
Join Arun Ulag at MPPC23

Join Arun Ulag at MPPC23

Get a sneak peek into this year's Power Platform Conference Keynote.

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.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

View All
Top Solution Authors
View All
Top Kudoed Authors
View All