Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have a sample table, in that i sales id i need to create the age for the sales id's as per the status
if the status is open
From "Created Date" till Today ; If CLOSED (WON or LOST) From "Created Date" till "WonLostDate"
kindly help me on this
need to write a measure
Solved! Go to Solution.
@Mahesh450 Maybe:
Column =
SWITCH(TRUE(),
[Status] = "Open", ( TODAY() - [Created Date] ) * 1.,
[Status] = "Won" || [Status] = "Lost", ( [WonLostDate] - [Created Date] ) * 1.
)
@Mahesh450 Maybe:
Column =
SWITCH(TRUE(),
[Status] = "Open", ( TODAY() - [Created Date] ) * 1.,
[Status] = "Won" || [Status] = "Lost", ( [WonLostDate] - [Created Date] ) * 1.
)
User | Count |
---|---|
57 | |
22 | |
18 | |
16 | |
11 |
User | Count |
---|---|
85 | |
54 | |
39 | |
21 | |
18 |