06-06-2017 07:47 AM
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% =
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 =
SUM('New_Returns (2)'[Returning Visitors]),
DATEADD('New_Returns (2)'[Time Period].[Date], -1, MONTH)
SUM('New_Returns (2)'[Returning Visitors]) - __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!