Return a Date based off another non-date value

Question

Hello all,&nbsp;I have a table with 2 columns: Category and Value.Based on the Category I want to add a date column.&nbsp;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.&nbsp;Maybe I've been spending too much time in Excel lately but I just cant figure this out. &nbsp;I dont mind doing this in the query editor or by adding a column in the model.&nbsp;Any help will be apprecaited.

greg_deckler · Accepted Answer

steigelbill&nbsp;- Perhaps:
&nbsp;
Column =
  SWITCH([Category],
    "Shipping Today",TODAY(),
    "Next Consolidation",TODAY() + 6 - WEEKDAY(TODAY()),
    BLANK()
  )

Forum Discussion

Return a Date based off another non-date value

2 Replies

Related content

Vlookup from Another Table Return Value from Column

Return value from another column

Return Last Non Blank Measure for All Dates in Table

SELECTEDVALUE measure from slicer keeps returning blank value when used on another measure

Return Column from another table in DAX