Forum Discussion
Accrue values by date
Hi roppozoppo ,
The solution is a bit complex but I made it.
And it is done in Power Query.
1.Copy a main table, then delete the other columns, and keep a distinct field, NOMBRE.
2.Add an index column. It's to sort the NOMBRE column.
3.Add a custom column to crossjoint the date table. The date table is Table (3). It contains all distinct dates from main table. Expand it.
4.Merge the new table with the main table as follows. Expand the MONTO column.
5.Fill down the MONTO column group by the NOMBRE column.
6.Filter out the null of the MONTO column.
7.Sort the NOMBRE column by the Index column. Here's the result.
You can download the attachment for details.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi roppozoppo ,
The solution is a bit complex but I made it.
And it is done in Power Query.
1.Copy a main table, then delete the other columns, and keep a distinct field, NOMBRE.
2.Add an index column. It's to sort the NOMBRE column.
3.Add a custom column to crossjoint the date table. The date table is Table (3). It contains all distinct dates from main table. Expand it.
4.Merge the new table with the main table as follows. Expand the MONTO column.
5.Fill down the MONTO column group by the NOMBRE column.
6.Filter out the null of the MONTO column.
7.Sort the NOMBRE column by the Index column. Here's the result.
You can download the attachment for details.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
You are a genius!!!! Thank you very very very much! This is what i looking for!!!
Regards