Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi All,
I am trying to create almost a date hieracrhy for a new date coloumn.
In my datasheet I have the following dates in order of importance:
- 1st Priority actualshipdate (ASD) (Date product was shipped)
- 2nd Priority Confirmed Delivery Date (CDD) (Date product has been booked to ship)
- 3rd Priority Expected Delivery Date (EDD) (Product expecting to ship but not yet)
I want a new column to to fill in data using the ASD data frist, if that is blank then use CDD if that is blank then use (EDD).
What is the best way to do so? example below. If there are multiple date fields filled in take in order of above.
(Made a mock up in excel to show - I am trying to create col 'Expected Result'
@Daniel29195 @amitchandak @Ritaf1983 @Ahmedx
Solved! Go to Solution.
Hello @cfurminger
try this DAX
ExpectedDate = COALESCE([ASD], [CDD], [EDD])
Or this
ExpectedDate =
IF(
NOT(ISBLANK([ASD])),
[ASD],
IF(
NOT(ISBLANK([CDD])),
[CDD],
[EDD]
)
)
See if this is helpful
Hello @cfurminger
try this DAX
ExpectedDate = COALESCE([ASD], [CDD], [EDD])
Or this
ExpectedDate =
IF(
NOT(ISBLANK([ASD])),
[ASD],
IF(
NOT(ISBLANK([CDD])),
[CDD],
[EDD]
)
)
See if this is helpful
User | Count |
---|---|
120 | |
69 | |
68 | |
57 | |
50 |
User | Count |
---|---|
166 | |
82 | |
68 | |
65 | |
54 |