Populate cell value to below x cells

Question

Hello community!&nbsp;I'm really new in Power BI and ran into an issue that I can't figure out. I need to add month values to the column next to the QTY to be able to see qty of certain month. The data is coming from Sharepoint list where one of the columns is "Month".&nbsp;&nbsp;I was thinking if it was maybe possible to populate value of month name into next 8 cells somehow, because 8 cells is always a constant? So that there is month name in one cell and next eight cells in the column have the same month name as well.&nbsp;&nbsp;Thanks in advance!&nbsp;

jthomson · Accepted Answer

Should be able to do this in a couple of steps - first I'd replace anything that says other with a null, and then you should be able to use Table.FillDown to get the result you want

Forum Discussion

Populate cell value to below x cells

2 Replies

Related content

Values not populating properly in Visuals

Population dynamic graaph

populate a column from a previous value

Copy activity dynamically populated additional columns error when using Expression values

Populate value in one column by dynamic value in another column