Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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.
User | Count |
---|---|
90 | |
84 | |
65 | |
62 | |
58 |
User | Count |
---|---|
147 | |
113 | |
95 | |
81 | |
71 |