How to create calendar table showing latest 2 years

[PBI_learner0]

How can i create a calendar table in power bi showing latest 2 years (current and previous year)?

[Ashish_Mathur · Accepted solution]

Hi,

Try this calcuated table formula

Calendar = calendar(date(year(today())-1,1,1),today())

If you want the Calendar table to extend till the last day of the current year, then try this

Calendar = calendar(date(year(today())-1,1,1),eomonth(date(year(today()),1,1),11))

Hope this helps.

[PBI_learner0]

thanks!

[Ashish_Mathur]

You are welcome.