Power Query Align Reporting Timeframes

[EBGAL]

Hi,

I have this table:

MonthYear	MaterialId	Price
Jan-18	A	2
Feb-18	A	3
Jun-18	A	4
Jun-18	B	2
Aug-18	B	4

I want to create the below table

Jan-18	A	2
Feb-18	A	3
Mar-18	A	4
Apr-18	A	4
May-18	A	4
Jun-18	A	4
Jul-18	A	4
Aug-18	A	4
Jan-18	B	2
Feb-18	B	2
Mar-18	B	2
Apr-18	B	2
May-18	B	2
Jun-18	B	2
Jul-18	B	4
Aug-18	B	4

The idea is to have the earliest and all consequitive months until the latest month present in the dataset for each single material. Whenever a value for the price is not available (e.g., Jan to May for Material B) it should look up to the next available value and when there is no next value (e.g., MaterialId = A, months Jul and Aug) then look up the last available value.

Thanks

Evan

[v-henryk-mstf]

Hi @EBGAL ,

It doesn't seem very clear what you need, can you further describe your business requirements and screenshots of the desired outcome?

Looking forward to your reply.

Best Regards,
Henry