Forum Discussion
Helper VCreate Date Table based on Min/Max of Existing Data
go to ..> Model --> choose --> new table,
As per your requirement, use below formula to create table.
Table = CALENDAR(MIN('Earlier'[Date]), MAX('Earlier'[Date]) )
If it is solution to query, accept as solution... it is useful to others....
Resolver I
go to ..> Model --> choose --> new table,
As per your requirement, use below formula to create table.
Table = CALENDAR(MIN('Earlier'[Date]), MAX('Earlier'[Date]) )
If it is solution to query, accept as solution... it is useful to others....
Is it possible to pull this formula created table into the "power query editor" where we can add date columns with date properties such as day of week, quarter 1, etc? Like the screen below.
Did you ever find a solution to your question? I am trying to do the same thing myself.
Try this:
Date = ADDCOLUMNS (CALENDARAUTO(),"Year", YEAR ([Date]),"Month", FORMAT([Date], "mmmm"),"Month Number", MONTH([Date]),"Quarter", FORMAT([Date], "\QQ"))
this is awesome! Exactly what I was looking for.
