fill empy cell

2 Topics

Fill Blanks with latest,
Hello Community, please consider helping me out here. I have this dataset of payments registered in the company, wich is imported monthly from xlsx file. A B C D E F G 4 1583181 0 6 28/12/2020 5/1/2021 -0,16 12 1524 4 7 5/1/2021 5/1/2021 1892,05 4 1583181 0 7 5/1/2021 1712 1 225421 0 1 12/1/2021 12/1/2021 672,05 4 1583181 0 8 12/2/2021 12/2/2021 -1711,84 1 225421 0 2 10/2/2021 12/2/2021 672,05 4 1583181 0 9 12/2/2021 1711,84 For each product (each one is a combination [A]-[B]), payments are scheduled in a series of dues, whose secuential number for each product is [D]. Each Due has a foreseen date for payment [E] and an effective paymen date [F], wich may be earlier or later. Some clients may introduce changes to the terms of the service wich are registered secuentially for each product in notes [C]. Lastly, [G] is the amount pactually payed. My issue here is that, as you can see above, some due dates [E] are null in the dataset, and I need to find the way to fill them, for each product (combination [A]-[B]), with the last non-blank date in previous dues [D]. There are nearly 100k records each month, and they are mixed, and usually the date needed for filling is not within the montly batch, so the function "fill down" at PowerQuery is not usefull here. In the above case, it should be 28/12/2020 in the first null and 12/2/2021 in the second empty cell. I don´t have too much experience with this and can´t figure it out how to solve this with PowerQuery or DAX syntax.
Solved
DavidGolden
4 years ago Place DAX Commands and Tips
4.3KViews
0likes
4Comments
How to create a Measure that fills the empty cells with the previous value
I need to compare Column A with Column B. I want to fill the empty cells with the previous value. Date A B 1.1. 1021 913 2.1. 1201 3.1. 1381 4.1. 1669 1525 Date A B 1.1. 1021 913 2.1. 1021 1201 3.1. 1381 1201 4.1. 1669 1525 Thank you! Regards! Veronika
veronika_prexl
6 years ago Place DAX Commands and Tips
913Views
0likes
2Comments