Forum Discussion
SDPowerBI123
4 years agoRegular Visitor
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...
- 4 years ago
Hi,
Create this calculated table formula
Calendar = calendar(date(2020,1,1),eomonth(today(),-1))
Hope this helps.
Ashish_Mathur
Super User
4 years agoHi,
Create this calculated table formula
Calendar = calendar(date(2020,1,1),eomonth(today(),-1))
Hope this helps.
- SDPowerBI1234 years agoRegular Visitor
amazing, thank you.
- Ashish_Mathur4 years ago
Super User
You are welcome.