calculated column

[Amz_123]

Hi Community,
Need Calculated Column for two dates in which date field is in one column. In my case I am having ID and Date Field as column value. I need number of days between the id login first time and day cap between second login.
Somewhat similar to this

Regards,
Sowmiya

[v-yuta-msft · Accepted solution]

@Amz_123 ,

Create a calculate column using DAX below:

Difference between First Login and Second Login = 
VAR Current_Date = 'Table'[Date]
VAR Current_ID = 'Table'[ID]
VAR First_Login_Date = CALCULATE(MIN('Table'[Date]), FILTER('Table', 'Table'[ID] = Current_ID))
VAR Interval = DATEDIFF(First_Login_Date, Current_Date, DAY)
RETURN
IF(Interval = 0, 0, Interval + 1)

 

Community Support Team _ Jimmy Tao

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