Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 months ago
Solved

Calendar type column needed

I've calendar so i need separate column for Type 

Dax calculated column needed:

if date contains current quarter or future quarter then 'future-target" else "achieved-target" suggest DAX.

 

example today date is 26th Sep 2025 so after 1st July 2025 all are called "future-target" anything coming prior quarter then achieved target. this column was dynamic based on system date.

 

table :

 

Need Help
  • bhanu_gautam's avatar
    bhanu_gautam
    10 months ago

    Anonymous , Try using

    dax
    Type =
    VAR CurrentQuarter = QUARTER(TODAY())
    VAR CurrentYear = YEAR(TODAY())
    VAR RowQuarter = QUARTER([Date])
    VAR RowYear = YEAR([Date])
    RETURN
    IF(
    (RowYear > CurrentYear) || (RowYear = CurrentYear && RowQuarter >= CurrentQuarter),
    "future-target",
    "achieved-target"
    )

1 Reply

  • bhanu_gautam's avatar
    bhanu_gautam
    Super User
    10 months ago

    Anonymous , Try using

    dax
    Type =
    VAR CurrentQuarter = QUARTER(TODAY())
    VAR CurrentYear = YEAR(TODAY())
    VAR RowQuarter = QUARTER([Date])
    VAR RowYear = YEAR([Date])
    RETURN
    IF(
    (RowYear > CurrentYear) || (RowYear = CurrentYear && RowQuarter >= CurrentQuarter),
    "future-target",
    "achieved-target"
    )