Return a Date based off another non-date value

[steigelbill]

Hello all,

I have a table with 2 columns: Category and Value.

Based on the Category I want to add a date column.

The categories are Shipping Today which should give today's date, Next Consolidation, which should give Friday's date, and then there are a few others that will be blank for the date for a variety of reasons.

Maybe I've been spending too much time in Excel lately but I just cant figure this out.  I dont mind doing this in the query editor or by adding a column in the model.

Any help will be apprecaited.

[Greg_Deckler · Accepted solution]

@steigelbill - Perhaps:

Column =
  SWITCH([Category],
    "Shipping Today",TODAY(),
    "Next Consolidation",TODAY() + 6 - WEEKDAY(TODAY()),
    BLANK()
  )

[steigelbill]

Works like a champ! It's always great to find new functions.  Thanks much Greg!