Forum Discussion
Loading rolling 12 month plus 1 extra month data into power BI report
Dear all,
I have a power querry related question.
I have data from 1-01-1990 till 01/01/2023. And now I only want to load rolling 12 months data plus March 2020 in my power bI report. Let's suppose my latest date in data is 01/12/2022 and I want to load from 01/12/2022 till 01/01/2022 and March-2020. But when my process run tomorrow we will have another month added into the data and latest date will become 01/01/2023 so then my report should load data from 01/01/2023 till 01/02/2022 plus March-2020.
| Load today | Load tomorrow | ||
| Date | Transation | Date | Transation |
| 01/03/2020 | 1003 | 01/03/2020 | 1003 |
| 01/01/2022 | 1025 | 01/02/2022 | 1026 |
| 01/02/2022 | 1026 | 01/03/2022 | 1027 |
| 01/03/2022 | 1027 | 01/04/2022 | 1028 |
| 01/04/2022 | 1028 | 01/05/2022 | 1029 |
| 01/05/2022 | 1029 | 01/06/2022 | 1030 |
| 01/06/2022 | 1030 | 01/07/2022 | 1031 |
| 01/07/2022 | 1031 | 01/08/2022 | 1032 |
| 01/08/2022 | 1032 | 01/09/2022 | 1033 |
| 01/09/2022 | 1033 | 01/10/2022 | 1034 |
| 01/10/2022 | 1034 | 01/11/2022 | 1035 |
| 01/11/2022 | 1035 | 01/12/2022 | 1036 |
| 01/12/2022 | 1036 | 01/01/2023 | 1037 |
1 Reply
Dear Shak_Stoke,
This can be achieved with Incremental Refresh, setting up the refresh to be 13 months from today.
Regards
