Say I am importing something like the following into PowerBI:
Date | Quantity
|---------------------|------------------|
| 1/1/2018 | 22 |
| 1/3/2018 | 30 |
| 1/4/2018 | 10 |
|---------------------|------------------|
Where the external source table is a series of date, value rows with some date values missing. I'd like to execute some DAX/M to add any missing date rows into the data set, where 'Quantity' value is taken from the first date prior. So my resulting dataset would like like this:
Date | Quantity
|---------------------|------------------|
| 1/1/2018 | 22 |
| 1/2/2018 | 22 |
| 1/3/2018 | 30 |
| 1/4/2018 | 10 |
|---------------------|------------------|
Can this be done in PowerBI?
Help is much appreciated!