Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
steigelbill
Frequent Visitor

Return a Date based off another non-date value

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.

1 ACCEPTED SOLUTION
Greg_Deckler
Super User
Super User

@steigelbill - Perhaps:

 

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

@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

2 REPLIES 2
Greg_Deckler
Super User
Super User

@steigelbill - Perhaps:

 

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

@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.