Forum Discussion
Helper VCreate 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.
For example, I have a table that tracks service requests which all have a start date and an end date. If I want my date table to start at the MIN Service Rquest Start Date and end at the MAX Service Request Start Date, is that possible?
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....
5 Replies
venug20Resolver 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....
