Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Running total with 0 values

Hi,    I have this table in my model :   DAY_ORDER    SHIFT         WEEKDAY    QUANTITY 1 NIGHT_SHIFT_WD MON 70 1 MORNING_SHIFT_WD MON 43 1 EVENING_SHIFT_WD MON 75 2 NIGHT_...
Need Help
  • smpa01's avatar
    smpa01
    6 years ago

    Anonymous You can create an additional measuere as

     

    Measure = SUMX('Table','Table'[QUANTITY])
     
    and new measure
    Measure 2 = IF([Measure]=0,0,[QUANTITY running total in WEEKDAY])
     
TomMartens's avatar
TomMartens
Super User
6 years ago

hey Anonymous ,

 

you can use WEEKDAY(TODAY() , ...) to find out the daynumber of the weekday, incorporate into your statement and return BLANK() if DAY_ORDER is greater than WEEKDAY(TODAY() , ...).

 

Hopefully, this provides some new ideas that will help to tackle your challenge.

 

Regards,

Tom