Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Dear Community,
Here is my dataset, would like to know a dax if actual time is blank, will refer the date of DeliveryTime. (Only retreive Delivery time when Actual Time is blank)
Appreciate and thanks for your time help me on this matter.
Here the pbix: https://ufile.io/ymqjsspu
Solved! Go to Solution.
@NickProp28 , Try new column
new column = coalesce([ActualTime],[DeliveryTime])
or
new column = if(isblank([ActualTime]),[DeliveryTime],[ActualTime])
@NickProp28 , Try new column
new column = coalesce([ActualTime],[DeliveryTime])
or
new column = if(isblank([ActualTime]),[DeliveryTime],[ActualTime])
@NickProp28 - Should be:
Column = IF(ISBLANK([ActualTime]),[DeliveryTime],[ActualTime])
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |