Adjusted Comp. Requests Amount =
VAR CurrentPeriod =
VALUES ( 'Date'[Date] )
VAR ComparisonPeriod =
CALCULATETABLE (
VALUES ( 'Date'[Date] ),
REMOVEFILTERS ('Date'),
USERELATIONSHIP ('Date'[Date], 'Comparison Date'[Comparison Date] )
)
VAR ComparisonSales =
CALCULATE ( "Measure"
}, ComparisonPeriod )
VAR DaysInCurrentPeriod =
COUNTROWS ( CurrentPeriod )
VAR DaysInComparisonPeriod =
COUNTROWS ( ComparisonPeriod )
VAR DailyComparisonSales =
DIVIDE (
ComparisonSales,
DaysInComparisonPeriod
)
VAR Result =
DaysInCurrentPeriod * DailyComparisonSales
RETURN
Result
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter