Forum Discussion

Br1-981's avatar
Br1-981
Helper I
3 years ago

Table using time without holes

Hi,

I have a DATA Table including a Date and some measurement and attributes.

From the Date I've created a custom column WEEKNUMBER using this formula:

WEEK_NUMBER = WEEKNUM(Data[Date Start].[Date])

Now I want to build a table using these

And the result is this:

What I want is to have as colums all the 52 weeks of a year, even if there are no values included, is it possible?

Thanks in advance

 

Bruno

Need Help
Tips and Tricks

2 Replies

  • serpiva64's avatar
    serpiva64
    Solution Sage
    3 years ago

    Hi,

    in your column Week_Number you have to enable "Show items with no data"

    If this post is useful to help you to solve your issue, consider giving the post a thumbs up and accepting it as a solution!

     

    • Br1-981's avatar
      Br1-981
      Helper I
      3 years ago

      It is working for months but not for the week number:

      Is it possible that is based on the fact that it is calculated column based only on valued data?