Forum Discussion

cfurminger's avatar
cfurminger
Frequent Visitor
1 year ago
Solved

How to write IF THEN for Multiple Date Columns Power Bi

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...
Need Help
  • nilendraFabric's avatar
    nilendraFabric
    1 year ago

    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 

     

nilendraFabric's avatar
nilendraFabric
Icon for Super User rankSuper User
1 year ago

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