Forum Discussion
Display Next Quarter Records in the Table
- Anonymous5 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.
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.