I want to create Quarter-on-Quarter % Change in Direct Query mode in Power BI
Creating measures like Quarter on Quarter percentage is quite easy is Import mode in power BI. But if we try them in Direct Query mode, the time intelligence measures are not available.
I even tried the DAX generated for Quarter-on-Quarter % Change in Import mode(as shown below) to do the same in Direct Query mode. But Time intelligence functions does not work in Direct Query mode.
Count of IssueId QoQ% =
IF(
ISFILTERED('services_user stat_view'[CreatedDate]),
ERROR("Time intelligence quick measures can only be grouped or filtered by the Power BI-provided date hierarchy or primary date column."),
VAR __PREV_QUARTER =
CALCULATE(
COUNTA('services_user stat_view'[IssueId]),
DATEADD(
'services_user stat_view'[CreatedDate].[Date],
-1,
QUARTER
)
)
RETURN
DIVIDE(
COUNTA('services_user stat_view'[IssueId])
- __PREV_QUARTER,
__PREV_QUARTER
)
)
Could you please help?