Help with DAX to count number of cases that arrived and finished in different dates

[Anonymous]

Hi everyone,

My dataset includes 3 columns, 1)case id 2)repair arrived date 3)repair finished date.

I want to combine the two different dates and the number of the cases in the same graph. I created a Date table in PowerBI, I chose the "repair arrived date"to be the active relationship for the date and I want to count the number of the cases that arrived and finished each month. How can I write my DAX function? Thank you.

[johnt75]

Create an inactive relationship from date to the finished date column and you can use

Num finished =
CALCULATE (
    COUNTROWS ( 'Table' ),
    USERELATIONSHIP ( 'Date'[Date], 'Table'[Finished date] )
)

Num arrived would be a simple COUNTROWS('Table')