Forum Discussion

gill_thornton's avatar
gill_thornton
Helper I
2 years ago
Solved

Calculated Column to Identify Current Date Between Two Random Term Dates

Hi, I hope someone can help.  I have a table containing our school term dates (start & end dates) and wish to flag which term is the current term based on this.  Any help would be much apprectiated.

 
 
 
Need Help
  • bhanu_gautam's avatar
    bhanu_gautam
    2 years ago

    gill_thornton , You can create a calculated column as per below DAX , fill free to update condition as per your requirements

     

    DAX
    CurrentTermFlag =
    VAR CurrentDate = TODAY()
    RETURN
    IF(
    CurrentDate >= TermDates[StartDate] && CurrentDate <= TermDates[EndDate],
    "Current Term",
    "Not Current Term"
    )

2 Replies

  • bhanu_gautam's avatar
    bhanu_gautam
    Super User
    2 years ago

    gill_thornton , You can create a calculated column as per below DAX , fill free to update condition as per your requirements

     

    DAX
    CurrentTermFlag =
    VAR CurrentDate = TODAY()
    RETURN
    IF(
    CurrentDate >= TermDates[StartDate] && CurrentDate <= TermDates[EndDate],
    "Current Term",
    "Not Current Term"
    )