Forum Discussion

TiaCamilian's avatar
TiaCamilian
Resolver I
7 years ago
Solved

Calculate code by weeks

  I have a table with a startDateTime and Code1. I need to be able to Filter the date using a calendar table by doing FILTER(ALL('Calendar'[Date]), AND('Calendar'[Date] >= TODAY(), 'Calendar'...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    HI TiaCamilian ,

     

    You can try to use following measure if it works for your requirement:

     

    SumCode6 =
CALCULATE (
    COUNT ( MovesConfirm[Code1] ),
    ALLSELECTED ( 'MovesConfirm' ),
    VALUES ( 'MovesConfirm'[WeekNumber] )
)

     

     

    Regards,
    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
7 years ago

HI TiaCamilian ,

 

You can try to use following measure if it works for your requirement:

 

SumCode6 =
CALCULATE (
    COUNT ( MovesConfirm[Code1] ),
    ALLSELECTED ( 'MovesConfirm' ),
    VALUES ( 'MovesConfirm'[WeekNumber] )
)

 

 

Regards,
Xiaoxin Sheng

TiaCamilian's avatar
TiaCamilian
Resolver I
7 years ago

This works.

 

Thank you