Table using time without holes

[Br1-981]

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

[serpiva64]

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]

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?