Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
How can i create a calendar table in power bi showing latest 2 years (current and previous year)?
Solved! Go to 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.
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.
thanks!
You are welcome.