I'm trying to visualize Google Analytic pageviews month over month percentage change. The quick measure gives me value of 0%. I'm using a DimDate table with a date hierarchy. I'm not sure where the problem is.
My goal: compare the total pageviews this month as a percentage of change vs last month's total pageviews.
Pageviews MoM% =
ERROR("Time intelligence quick measures can only be grouped or filtered by the Power BI-provided date hierarchy or primary date column."),
VAR __PREV_MONTH =
DATEADD('DimDate'[Date].[Date], -1, MONTH)
SUM('FactSCRAMAnalytics'[Pageviews]) - __PREV_MONTH,
Solved! Go to Solution.