Forum Discussion

AKA333's avatar
AKA333
Regular Visitor
9 years ago
Solved

IF Statement Custom Column

I have two date columns new target delivery date and Original Delivery date

 

if New > original, then the column should read Late

 

if new <= original, then the column should read On Schedule.

 

dates readas mm/dd/yyyy

  • AKA333's avatar
    AKA333
    9 years ago

    thank you that worked after I figured out I had to be in the Data tab not the report tab...

6 Replies

  • AKA333's avatar
    AKA333
    Regular Visitor
    9 years ago

    What would the IF statement look like?  I have tried several variations to no avail.

    • MarcelBeug's avatar
      MarcelBeug
      Community Champion
      9 years ago

      I'm not at all a DAX-expert, but this looks pretty straightforward, so I wonder what you tried?

       

      Column = IF(Query1[New Target Delivery Date]>Query1[Original Target Delivey Date];"Late";"On Schedule")

      Or are you looking for a Power Query solution?

       

      • AKA333's avatar
        AKA333
        Regular Visitor
        9 years ago

        semi-colons are not allowed.  So here is what I entered...

        Column5 = IF(BuildTracker[New_TargetDeliveryDate]>BuildTracker[DeliveryDate],"Late","On Schedule")

         

        But when I hit enter, I do not see a new column nor does that come back with an error?