Forum Discussion

Mike_Mace's avatar
Mike_Mace
Resolver I
5 years ago
Solved

Matrix subtraction stop at current week

Happy lockdowning Forum,   I have a matrix with info: 1. A list of 25 deliverables with random plan dates and random dates they were submitted 2. I created (head) columns by "starting-date" week....
Need Help
  • mwegener's avatar
    mwegener
    5 years ago

    Sorry, I fooled myself.

    failed 2 = 
SUMX (
    VALUES ( 'Date Calendar'[Week start] ),
    IF (
        'Date Calendar'[Week start]
            < TODAY () - WEEKDAY ( TODAY (), 2 ) + 1,
        CALCULATE(SUM ( 'plan date'[plan sum] ) - SUM ( 'submission date'[sub sum] )),
        BLANK ()
    )
)

     

Mike_Mace's avatar
Mike_Mace
Resolver I
5 years ago

Hi mwegener 

It looks like new "failed 3" has same results as "failed 2". I gave them a different highlight on the snip to read with ease. Still no row/grand totals
Is there a way around this or do i need to rethink model structure?

 

 

mwegener's avatar
mwegener
Most Valuable Professional
5 years ago

Sorry, I fooled myself.

failed 2 = 
SUMX (
    VALUES ( 'Date Calendar'[Week start] ),
    IF (
        'Date Calendar'[Week start]
            < TODAY () - WEEKDAY ( TODAY (), 2 ) + 1,
        CALCULATE(SUM ( 'plan date'[plan sum] ) - SUM ( 'submission date'[sub sum] )),
        BLANK ()
    )
)