Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have to create the difference between the physical date and the created on date, using the the "received pricing" status in the workflow status.
I am needing to know how many days it took to get to that specific status("Received pricing" in the workflow status columns-which has multiple different status types).
so basically how many days between physical date to created date with the filter "received pricing" in the workflow status column.
Please advise.
Look at you status it look like you have a "-" before
Hi
Try this as a measure :
in text form :
Hi,
I put this code:
NBDays =
var statusG=SELECTEDVALUE(cr93f_cpsoo[Workflow Status])
return
if(statusG="Received Pricing",DATEDIFF(SELECTEDVALUE(cr93f_cpsoo[createdon.date]),SELECTEDVALUE(cr93f_cpsoo[Physical Date]),DAY),0)
All the days just show as 0. Please advise.
User | Count |
---|---|
51 | |
38 | |
20 | |
14 | |
13 |
User | Count |
---|---|
98 | |
71 | |
29 | |
20 | |
13 |