cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
DECOVIOTI
Helper III
Helper III

End Date in my calendar tables.

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 ?

1 ACCEPTED SOLUTION

Hi,

 

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

36.PNG

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

 

View solution in original post

6 REPLIES 6
v-gizhi-msft
Community Support
Community Support

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

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

 

Hi,

 

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

31.PNG

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

 

Best Regards,

Giotto

Hello @v-gizhi-msft 

 

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

See below pls2020-04-16_14-22-00.png

 
 
 

Hi,

 

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

36.PNG

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

 

View solution in original post

amitchandak
Super User IV
Super User IV

In case you have generated calendar using dax

This can be done

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



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors