Adjusted time comparison
Thu Mar 17 2022 09:23:26 GMT+0000 (Coordinated Universal Time)
Saved by
@valdemar
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
content_copyCOPY
Comments