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