30/60/90

[ZGardner]

Hello, I apologize in advance for this seemingly ignorant question. I am new to PowerBI and have been tasked with creating a visualization for a specific dataset. My issue is that I need to take a single column with dates (DEADLINE) and denote how many of these dates are 30 days away/60 days away and 90 days away.

I've tried other solutions posted on the boards but have had little success in accomplishing exactly what I am trying to do.

Thanks for your help in advance. 

[ryan_mayu]

@ZGardner 

could you please provide the sample data and expected output?

[Greg_Deckler · Accepted solution]

@ZGardner Easiest would be to do something like the following:

Days Away Column = 
  VAR __Days = (TODAY() - [DEADLINE]) * 1.
RETURN
  SWITCH(TRUE(),
    __Days <= 30,"30",
    __Days <= 60,"60",
    __Days <= 90,"90",
    "90+"
  )