Time series

[Anonymous]

Hi all, 

below is the screenshot of the visual that I have made in my power bi and now I need to include the weeks inbetween as well.

So for e.g., for week-50 under contractual date is 1500 and then directly the value is 1000 for week-52 but what i want is it to show week-51 as well with nothing but value form previous week which would be 1500. So in a way I want a continuous time series and system to show value from previous week for the week that doesnt have any data entry or is simply blank.

Please help me

[v-shex-msft · Accepted solution]

Hi @Anonymous,

I'd like to suggest you convert the year week field to numeric type(year *100 +week number), then you can simply extract the current year week value as condition to find out the previous value.

BTW, if these blank parts not real include in your table. You may need to use the calendar table date field as row , the raw table category as column, then write a formula to check current date and category to lookup raw table records and do above process if the current cell does not include matched records.

Regards,

Xiaoxin Sheng