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 |
---|---|
93 | |
87 | |
68 | |
62 | |
58 |
User | Count |
---|---|
149 | |
113 | |
95 | |
80 | |
72 |