Forum Discussion

Caitlin_Knox's avatar
Caitlin_Knox
Advocate III
9 years ago
Solved

Calculating current Quarter

I'm trying to create a calculated column to return the current quarter like I do for current month. I use these mostly as a visualization filter so the report updates to the current information. Thi...
Need Help
  • Flori_Abb's avatar
    Flori_Abb
    9 years ago

    Hi Caitlin_Knox

     

    i guess you enter this formula in a date table and you want to add a column what shows you 1 if the date is the current quater. In this case i added before a quaternumber column:

     

    QuaterNumber = if(dim_Date[Year] = year(now());roundup(dim_Date[MonthNumberOfYear]/3;0);0) and then

     

    Current QTD = if(dim_Date[QuaterNumber] = roundup(month(now()-1)/3;0);1;0)

    That works for me fine, maybe it helps you also.

    KR

    Florian

SBoraste's avatar
SBoraste
Regular Visitor
6 years ago

You can calculate the current Quarter Sales using below DAX:

CY Quarter = CALCULATE(SUM('Sample Data'[Total Budget]),YEAR('Sample Data'[Project Start Date])=YEAR(TODAY()),
'Date Table'[QuarterOfYear]=ROUNDUP(MONTH(TODAY()) / 3, 0))