End Date in my calendar tables.

[Anonymous]

Hello

How are you?

My name is Andre and I am a power professional

I am using the code  = Date.EndOfYear(DateTime.Date(DateTime.FixedLocalNow()))

I am trying to set up an automatic End Date in my calendar tables.  Base on that, we are in 2020 now and the table is showing the months until December 2020 and when we will be in 2021, the calendar table will be an automatic update to December 2021??

Is my assumption correct?

Can anyone pls help me ?

[Anonymous]

Hi All,

I am working on forecasting for shipments and created a calendar table. What should be my end date?

Should my end date be the last date of my forecasting model or ladt date of my last shipment in the data set?

[v-gizhi-msft]

Hi,

Please try this calculated table:

Calendar =
CALENDAR (
    DATE ( YEAR ( TODAY () ), 1, 1 ),
    DATE ( YEAR ( TODAY () ), 12, 31 )
)

Hope this helps.

If my answer has solved your issue, please mark it as a solution for others to see.

Thanks!

Best Regards,

Giotto

[Anonymous]

Hello @v-gizhi-msft 

Thanks for your reply.

I think my main question is: if I only use this Date.EndOfYear(DateTime.Date(DateTime.FixedLocalNow())), nothing else.

when we are in 1/1/2021, this function will display the whole year 2021?

Thanks

[v-gizhi-msft]

Hi,

This code will only show the last day of current year not the whole year, see this:

And i advise you using DAX expression to show the whole year as my posted upper.

Best Regards,

Giotto

[Anonymous]

Hello @v-gizhi-msft 

In my calendar table, I have the whole year of 2020

See below pls

[v-gizhi-msft · Accepted solution]

Hi,

After you apply your original code, it will automatically generate a table as below:

Then you can try this calculated table:

Calendar = CALENDAR(DATE(2020,1,1),MAX(Query1[Query1]))

The result will show the date from 2020/1/1 to the current year last date.

etc. if current year is 2021, the calendar table date will expand to the 2021/12/31.

Hope this helps.

Best Regards,

Giotto

[amitchandak]

In case you have generated calendar using dax

This can be done

 Calendar = Calendar(Date(2019,01,01),Date(year(today()),12,31))