Forum Discussion
Solved
how to make a calender table
hey i want to write dax to create a calender table, i want it to start the first day of 2020 and end on the last day of last month, the last day of last month should be dynamic so that as time goes o...
Hi,
Create this calculated table formula
Calendar = calendar(date(2020,1,1),eomonth(today(),-1))
Hope this helps.
MahyarTF
Memorable Member
Memorable MemberHi,
Use below website,
there is a video and also a full script for creating the Date dimension in Power Bi :
Appreciate for Kudos