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: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

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
233 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
210 Views
0
FreemanZ
Super User
Super User

‎11-29-2022 07:14 AM

can you share some sample data?

Message 2 of 4
220 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
173 Views
0

Helpful resources

Announcements
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

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!

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

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