Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Can some one help me in writing a calculated column formula to find the second min order date with respect to each user??
Thanks
Solved! Go to Solution.
@Learn_PBI Sample data would greatly help but it should be something along the lines of:
Column =
VAR __Customer = [Customer]
VAR __MinOrderDate = MINX(FILTER(ALL('Table'),[Customer] = __Customer),[OrderDate])
VAR __SecMinOrderDate = MINX(FILTER(ALL('Table'),[Customer = __Customer && [OrderDate] <> __MinOrderDate),[OrderDate])
RETURN
__SecMinOrderDate
@Learn_PBI Sample data would greatly help but it should be something along the lines of:
Column =
VAR __Customer = [Customer]
VAR __MinOrderDate = MINX(FILTER(ALL('Table'),[Customer] = __Customer),[OrderDate])
VAR __SecMinOrderDate = MINX(FILTER(ALL('Table'),[Customer = __Customer && [OrderDate] <> __MinOrderDate),[OrderDate])
RETURN
__SecMinOrderDate
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
117 | |
101 | |
71 | |
61 |