Forum Discussion

DineshDwilco's avatar
DineshDwilco
Frequent Visitor
5 years ago
Solved

Display Next Quarter Records in the Table

Hi All,    I am Using NextQuarter function in the measure its count and sum funcation working fine. but need to display Next quarter records in the Table view  or bar charts. How will to do?
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi DineshDwilco 

    To use time intelligence functions like NextQuarter, you need to have a date table with continuous date.

    My Sample:

    Here we build a calendar table by dax code.

    Date =
    ADDCOLUMNS (
        CALENDARAUTO (),
        "Year", YEAR ( [Date] ),
        "Month", MONTH ( [Date] ),
        "MonthName", FORMAT ( [Date], "MMMM" ),
        "QTR", QUARTER ( [Date] )
    )

    Build an active relationship between two table's Date column.

    Then we use NextQuarter in our measure.

    NextQtrCount = CALCULATE(COUNT('Sample'[User]),NEXTQUARTER('Date'[Date]))
    CurQtrCount = COUNT('Sample'[User])

    Result is as below.

    Best Regards,

    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.