Reply
Frequent Visitor
Posts: 2
Registered: ‎06-06-2017

time intelligence quick measure

Hey guys, I have a queston about the time intelleigence quic kmeasure. I want to calculated monthly percentage change in new and return visitors and draw a line chart to show the trend, here is the syntax:

 

Returning Visitors MoM% =
IF(
ISFILTERED('New_Returns (2)'[Time Period]),
ERROR("Time intelligence quick measures can only be grouped or filtered by the Power BI-provided date hierarchy."),
VAR __PREV_MONTH =
CALCULATE(
SUM('New_Returns (2)'[Returning Visitors]),
DATEADD('New_Returns (2)'[Time Period].[Date], -1, MONTH)
)
RETURN
DIVIDE(
SUM('New_Returns (2)'[Returning Visitors]) - __PREV_MONTH,
__PREV_MONTH
)
)

 

 

The problem is, when I put the time period into the axis instead of powerbi's own date hierachy, here comes the error:

 

Time Intelleignce quick measure can only be grouped or filtered by the Pwer BI-provided date hierachy.

 

I am wondering if anyone know how to use user's own time period to draw the graph. Thanks a lot!