- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Appending sales data to build 24 month report from a report that only shows moving 13 months
Hi All,
I receive a sales report from a wholesaler covering 13 months. Currently the report shows Dec 2020; Jan 2021, Feb 2021 all the way to the current month Jan 2022. Once Jan 2022 is actualised, Dec 2020 will drop off from the report adding Feb 2022 and so on.
I have built a dashboard which is working perfectly for the 13 months BUT I would like to extent the historical view to 24 month. I would like to keep the Dec 2020 sales onwards which the report drops off as we move through 2022.
How do I get around that problem?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi, @SalterAU
Would you provide more information about the report (source table/s, data structure, measures) or share sample pbix/excel file not containing sensistive information in order to have a solution?
Did I answer your question? Mark my post as a solution!
https://allure-analytics.com/
https://www.youtube.com/channel/UCndD_QZVNB_JWYLEmP6KrpA
https://www.linkedin.com/company/77757292/
Proud to be a Super User!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hey @ALLUREAN
Below is an image of the source report.
The yellow highlighted column updates each week. Then on the first of every month, this column actualises for the full month and the last column in the report (in this case Dec 2020) drops off...giving the 13 months view. I want to keep the last column. I'm thinking that I will need to keep the old reports on file to keep the months that will drop off but then I will have 26 source files. But can't see any other workaround as the original report will always only be 13 month.
The data is transformed into three separate reports by unpivoting it.
This is the Sales table with the dates now running vertically as I unpivot the source table.
This is the visual
Hope this gives you more info.
Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Microsoft Fabric Community Conference 2025
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
Subject | Author | Posted | |
---|---|---|---|
06-30-2024 07:34 AM | |||
08-08-2024 06:08 PM | |||
06-18-2024 03:20 AM | |||
06-12-2024 10:15 AM | |||
03-24-2024 04:09 PM |
User | Count |
---|---|
118 | |
73 | |
56 | |
56 | |
44 |
User | Count |
---|---|
178 | |
120 | |
82 | |
68 | |
57 |