Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Dates measure or calculated column

Hi Experts   need a measure to do the following, If the date is in the past from Todays date the 1, if the date is the current month then 2, if the date is in future months/periods after the curren...
Need Help
  • jdbuchanan71's avatar
    jdbuchanan71
    4 years ago

    That would be like this.

    Formatting = 
VAR _Date = MAX ( Dates[Date] )
RETURN
SWITCH(
    TRUE(),
    _Date <= TODAY(),1,
    _Date <= EOMONTH(TODAY(),0),2,
    3
)

jdbuchanan71's avatar
jdbuchanan71
Icon for Super User rankSuper User
4 years ago

That would be like this.

Formatting = 
VAR _Date = MAX ( Dates[Date] )
RETURN
SWITCH(
    TRUE(),
    _Date <= TODAY(),1,
    _Date <= EOMONTH(TODAY(),0),2,
    3
)