Forum Discussion

bhmiller89's avatar
bhmiller89
Icon for Helper V rankHelper V
7 years ago
Solved

Create Date Table based on Min/Max of Existing Data

I usually create a date table for my data using the usual way of defining specific beginning and end dates. I wanted to know if it is possible to create a date table based on the existing data.    ...
Need Help
  • venug20's avatar
    venug20
    7 years ago

    bhmiller89

     

    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....

     

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Did you ever find a solution to your question? I am trying to do the same thing myself.

ValleyWalrus's avatar
ValleyWalrus
New Member
3 years ago

Try this:

 

Date = ADDCOLUMNS (CALENDARAUTO(),
"Year", YEAR ([Date]),
"Month", FORMAT([Date], "mmmm"),
"Month Number", MONTH([Date]),
"Quarter", FORMAT([Date], "\QQ")
)