Forum Discussion
Snapshot Comparison based on dynamic date selection
just an update how i solved this :
i created 2 tables for dates in SQL DB, uploaded them as independent tables and linked to the main table (which contained the meaures) using SELECTEDVALUE.
thanks all for inputs.
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information or anything not related to the issue or question.
If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
thanks,
The data table looks like below (table 1) where I have forecasted/actual sales captured everyweek for the same week.
I have created a filter for snapshot week single select filter for snapshot column where the user can see the comparison of latest snapshot and compare it with the pervious snapshot. The prev snapshot is another measure that i calculate in SQL using a windows function and upload it Power BI.
The user is looking for a capability for selecting any 2 snapshot and the resultant table (table 2)
please let me know if i need to provide more information.
thanks.
Table 2
| snapshot | total_forecasted_sales | ||
| 01/04/2024 00:00 | 11183 (J3) | ||
| 04/03/2024 00:00 | 90000 (J4) | ||
| Change in sales | =+J4-J3 | 78817 | |
| %age_change | =+(J4-J3)/J3 | 7.047929894 |
Table 1
| ITEM_ID | snapshot | salesweek | total_forecasted_sales |
| SKUA | 01/04/2024 00:00 | 01/04/2024 00:00 | 11183 |
| SKUA | 25/03/2024 00:00 | 01/04/2024 00:00 | 11183 |
| SKUA | 18/03/2024 00:00 | 01/04/2024 00:00 | 41200 |
| SKUA | 18/03/2024 00:00 | 01/04/2024 00:00 | 17349 |
| SKUA | 11/03/2024 00:00 | 01/04/2024 00:00 | 23543 |
| SKUA | 04/03/2024 00:00 | 01/04/2024 00:00 | 5886 |
| SKUA | 26/02/2024 00:00 | 01/04/2024 00:00 | 36110 |
| SKUA | 19/02/2024 00:00 | 01/04/2024 00:00 | 26486 |
| SKUA | 19/02/2024 00:00 | 01/04/2024 00:00 | 33504 |
| SKUA | 12/02/2024 00:00 | 01/04/2024 00:00 | 26486 |
| SKUA | 05/02/2024 00:00 | 01/04/2024 00:00 | 26486 |
| SKUA | 29/01/2024 00:00 | 01/04/2024 00:00 | 50029 |
| SKUA | 22/01/2024 00:00 | 01/04/2024 00:00 | 26486 |
| SKUA | 15/01/2024 00:00 | 01/04/2024 00:00 | 139050 |
| SKUA | 08/01/2024 00:00 | 01/01/2024 00:00 | 172010 |
| SKUA | 08/01/2024 00:00 | 01/04/2024 00:00 | 106283 |
| SKUA | 08/01/2024 00:00 | 01/05/2024 00:00 | 107598 |