Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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.
@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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
94 | |
74 | |
71 | |
64 |
User | Count |
---|---|
143 | |
109 | |
103 | |
82 | |
74 |