datediff based on 3 columns

[Anonymous]

Hi Experts

need a calculated column measure to give me datediff based on there column two date and one text

current measure = datediff(Incident[startdate],Incident[enddate],day), based on where status column where we are still Active.

ie. datediff for active items 

[Samarth_18]

Hi @Anonymous ,

If you need to create a calculate column then you can use below code:-

column =
IF (
    Incident[activity_status] = "Active",
    DATEDIFF ( Incident[startdate], Incident[enddate], DAY )
)

Thanks,

Samarth

[amitchandak · Accepted solution]

@Anonymous . This seems like a column then measure

current measure = calculate( Sumx(filter(Incident, Incident[Status] ="Active"), datediff(Incident[startdate] ,Incident[enddate] ,day ) ))