Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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])
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |