Adjusted time comparison

PHOTO EMBED

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