DateDiff using slicers

Hi Anonymous ,

Please check:

1. Enter data to create ColumnHeader1 table. The order is the count of task name +1.

2. Create ColumnHeader2 table.

ColumnHeader2 = 
UNION (
    ADDCOLUMNS (
        VALUES ( 'Table'[Task Name] ),
        "Order", CONVERT ( RIGHT ( [Task Name], SEARCH ( " ", [Task Name] ) - 3 ), INTEGER )
    ),
    ColumnHeader1
)

3. Create a slicer table.

Task Name Slicer = VALUES('Table'[Task Name])

4. Create measures.

Date Difference in Days = 
VAR T1 =
    MIN ( 'Task Name Slicer'[Task Name] )
VAR T1_Date =
    CALCULATE ( MAX ( 'Table'[Task Date] ), 'Table'[Task Name] = T1 )
VAR T2 =
    MAX ( 'Task Name Slicer'[Task Name] )
VAR T2_Date =
    CALCULATE ( MAX ( 'Table'[Task Date] ), 'Table'[Task Name] = T2 )
RETURN
    DATEDIFF ( T1_Date, T2_Date, DAY )

Value Measure = 
VAR Task_ =
    MAX ( 'ColumnHeader2'[Task Name] )
RETURN
    IF (
        Task_ = "Date Difference in Days",
        [Date Difference in Days],
        CONVERT (
            CALCULATE ( MAX ( 'Table'[Task Date] ), 'Table'[Task Name] = Task_ ),
            STRING
        )
    )

Measure = 
IF (
    MAX ( 'ColumnHeader2'[Task Name] ) = "Date Difference in Days",
    1,
    IF (
        MAX ( 'ColumnHeader2'[Task Name] ) IN VALUES ( 'Task Name Slicer'[Task Name] ),
        1
    )
)

5. Create a Matrix visual.

6. Then, you will get this:

BTW, .pbix file attached.

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi Anonymous ,

You can create your ColumnHeader1 table like this:

ColumnHeader1 =
ADDCOLUMNS (
    DATATABLE ( "ColumnHeader", STRING, { { "Date Difference in Days" } } ),
    "Order", DISTINCTCOUNT ( 'Table'[Task Name] ) + 1
)

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.