chart with start and end date

I would like to create a line chart based on data that only has a start and end date. Here is a sample of the data Type Start Date End Date IW 12/01/2017 12/31/2017 IW 12/01/2017 1...

Anonymous

8 years ago

Hi jeffr,

You can try to use below formula to generate the detail date table, then build relationship between original table and new table. After these steps, you can use new date form new table as the axis and drag id to value field with summary mode count.

Original table:

Sample:

Detail = 
VAR temp =
    SELECTCOLUMNS (
        'Sample',
        "Index", [Index],
        "StartDate", [StartDate],
        "EndDate", [EndDate]
    )
VAR vCalendar =
    CALENDAR ( MINX ( temp, [StartDate] ), MAXX ( temp, [EndDate] ) )
RETURN
    SELECTCOLUMNS (
        FILTER (
            CROSSJOIN ( temp, vCalendar ),
            [StartDate] <= [Date]
                && [EndDate] >= [Date]
        ),
        "Index", [Index],
        "StartDate", [StartDate],
        "EndDate", [EndDate],
        "Detail", [Date]
    )

Expand tableRelationship