Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 |
---|---|
102 | |
91 | |
84 | |
77 | |
71 |
User | Count |
---|---|
113 | |
104 | |
100 | |
73 | |
65 |