Forum Discussion
Fill down in a measure
Hi,
How can i fill down in a measure? for instance I have the measure sum of sales ( SUM(TABLE[sales] ) for only working days and I want to fill down in the week days with the las day where there is a sale (friday) or the holidays.
This is the original table
| Date | Weekday | Measure |
| 06-11-2023 | 1 | 386.126 |
| 07-11-2023 | 2 | 387.977 |
| 08-11-2023 | 3 | 391.834 |
| 09-11-2023 | 4 | 389.997 |
| 10-11-2023 | 5 | 382.240 |
| 11-11-2023 | 6 | |
| 12-11-2023 | 7 | |
| 13-11-2023 | 1 | 383.770 |
| 14-11-2023 | 2 | 386.766 |
| 15-11-2023 | 3 | 385.616 |
| 16-11-2023 | 4 | 386.674 |
| 17-11-2023 | 5 | 377.716 |
| 18-11-2023 | 6 | |
| 19-11-2023 | 7 | |
| 20-11-2023 | 1 | 378.017 |
| 21-11-2023 | 2 | 378.485 |
| 22-11-2023 | 3 | 374.086 |
| 23-11-2023 | 4 | 369.590 |
| 24-11-2023 | 5 | 371.346 |
| 25-11-2023 | 6 | |
| 26-11-2023 | 7 | |
| 27-11-2023 | 1 | 373.709 |
| 28-11-2023 | 2 | 378.620 |
| 29-11-2023 | 3 | 378.210 |
| 30-11-2023 | 4 | 381.357 |
And I need to fill down the blank values with the last non blank in the measure
| Date | Weekday | Measure |
| 06-11-2023 | 1 | 386.126 |
| 07-11-2023 | 2 | 387.977 |
| 08-11-2023 | 3 | 391.834 |
| 09-11-2023 | 4 | 389.997 |
| 10-11-2023 | 5 | 382.240 |
| 11-11-2023 | 6 | 382.240 |
| 12-11-2023 | 7 | 382.240 |
| 13-11-2023 | 1 | 383.770 |
| 14-11-2023 | 2 | 386.766 |
| 15-11-2023 | 3 | 385.616 |
| 16-11-2023 | 4 | 386.674 |
| 17-11-2023 | 5 | 377.716 |
| 18-11-2023 | 6 | 377.716 |
| 19-11-2023 | 7 | 377.716 |
| 20-11-2023 | 1 | 378.017 |
| 21-11-2023 | 2 | 378.485 |
| 22-11-2023 | 3 | 374.086 |
| 23-11-2023 | 4 | 369.590 |
| 24-11-2023 | 5 | 371.346 |
| 25-11-2023 | 6 | 371.346 |
| 26-11-2023 | 7 | 371.346 |
| 27-11-2023 | 1 | 373.709 |
| 28-11-2023 | 2 | 378.620 |
| 29-11-2023 | 3 | 378.210 |
| 30-11-2023 | 4 | 381.357 |
Thanks a lot.
pls try htis
2 Replies
pls try htis