Forecasting the Workload for an area for next week

DAX DAX Calculations
7

Hi Dan,

I’ve added a Measure [Plan v3], so it now shows [Actual] where the Sequence = 1
Just wrapped it in an IF statement, so you can change that easily should the need arise…

Here’s the file: OTD Test Power Bi Planning.pbix (987.6 KB)

Plan v3 = 

VAR myWeek = 
    CALCULATE( MAX( 'Date Table'[WeekOffset] ),
        FILTER( ALL( 'Date Table'),
            'Date Table'[Week Number] = SELECTEDVALUE( 'Date Table'[Week Number] ) &&
            'Date Table'[Year] = SELECTEDVALUE('Date Table'[Year] ) 
        ) 
    )
VAR mySequence = SELECTEDVALUE( 'OTD Area Definitions'[Sequence] )
RETURN

IF( mySequence = 1, [Actual],
    CALCULATE( [Actual],
        FILTER( ALL('Date Table'),
        'Date Table'[WeekOffset] = myWeek -1
        ),
        FILTER( ALL( 'OTD Area Definitions' ),
            'OTD Area Definitions'[Sequence] = mySequence -1    
        )
    )
)

.
@BrianJ, thank you for your feedback! :+1:

1 Like