Calendar by weeks

[Syndicate_Admin]

Hello everyone

I need your valuable help with the following question.

I have a database where exact calendar dates are not counted but time is defined by weeks. Similar to the following:

MONTH	WEEK	YEAR
April	14	2019

The database is fed weekly, so exact dates or days are not counted. This has made it difficult to create time metrics such as SAMEPERIODLASTYEAR using a calendar table.

How can I use Time Intelligence?

Thank you!

[PaulDBrown · Accepted solution]

This thread explains two ways of setting up a date or dimension table based on weeks:

How to set up a date table without a date column

[Syndicate_Admin]

Hello

Thank you very much for your prompt reply.

I'm really a newbie and I don't know how to use functions like SAMEPERIODLASTYEAR considering that this if or if it should carry the date field, but since the calendar table is set up by weeks, I don't have that column.

Thanks a lot

[PaulDBrown]

To use Time Intelligence you need the type of table described in the link under "1) Using a Date Table:"

Time intelligence requires the use of a date field, so you must use the date column in the date table. Does that help?