Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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.
I have 21 segments and 3 years worth data.. fw is week
can you share some sample data?
Desktop | 2020 | 1 | Segment1 | Organic | ANZ | Q1 | 781 |
Desktop | 2020 | 1 | Segment1 | Organic | CHN | Q1 | 3 |
Desktop | 2020 | 1 | Segment1 | Organic | HKT | Q1 | 330 |
Desktop | 2020 | 1 | Segment1 | Organic | IN | Q1 | 387 |
Desktop | 2020 | 1 | Segment1 | Organic | KOR | Q1 | 319 |
Desktop | 2020 | 1 | Segment1 | Organic | SEA | Q1 | 285 |
Desktop | 2020 | 1 | Segment1 | Paid Media | ANZ | Q1 | 683 |
Desktop | 2020 | 1 | Segment1 | Paid Media | CHN | Q1 | 2 |
Desktop | 2020 | 1 | Segment1 | Paid Media | HKT | Q1 | 133 |
Desktop | 2020 | 1 | Segment1 | Paid Media | IN | Q1 | 148 |
Desktop | 2020 | 1 | Segment1 | Paid Media | KOR | Q1 | 238 |
Desktop | 2020 | 1 | Segment1 | Paid Media | SEA | Q1 | 138 |
Desktop | 2020 | 1 | Segment1 | Product | ANZ | Q1 | 2162 |
Desktop | 2020 | 1 | Segment1 | Product | CHN | Q1 | 15 |
Desktop | 2020 | 1 | Segment1 | Product | HKT | Q1 | 479 |
Desktop | 2020 | 1 | Segment1 | Product | IN | Q1 | 339 |
Desktop | 2020 | 1 | Segment1 | Product | KOR | Q1 | 935 |
Desktop | 2020 | 1 | Segment1 | Product | SEA | Q1 | 342 |
Desktop | 2020 | 1 | Segment1 | Unknown | ANZ | Q1 | 19 |
Desktop | 2020 | 1 | Segment1 | Unknown | CHN | Q1 | 0 |
Desktop | 2020 | 1 | Segment1 | Unknown | HKT | Q1 | 8 |
Desktop | 2020 | 1 | Segment1 | Unknown | IN | Q1 | 14 |
Desktop | 2020 | 1 | Segment1 | Unknown | KOR | Q1 | 12 |
Desktop | 2020 | 1 | Segment1 | Unknown | SEA | Q1 | 7 |
Desktop | 2020 | 1 | Segment2 | Organic | ANZ | Q1 | 2888 |
Desktop | 2020 | 1 | Segment2 | Organic | CHN | Q1 | 239 |
Desktop | 2020 | 1 | Segment2 | Organic | HKT | Q1 | 985 |
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
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!