Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Time series

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 the...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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