Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Last week Dax

Dear All, 
 
I have this formula below to calculate period in date for weeks but it keeps bringing the wrong data 
 
Last week = CALCULATE([PPE Lsum], DATESINPERIOD('Calendar'[date], TODAY(),-7,DAY))
 
LastWeek = CALCULATE(SUM('Occupational Safety'[Value]),filter(ALL('Occupational Safety'[Week]),'Occupational Safety'[Week]=WEEKNUM(TODAY(),1)-1))
 
 
Please assist,
 
Need Help
Reporting
  • Anonymous's avatar
    Anonymous
    6 years ago

    ThanK you deevaker the solutioin worked. 

    LastWeek = CALCULATE(SUM('Occupational Safety'[Value]),filter(ALLEXCEPT('Occupational Safety','Occupational Safety'[PPE],'Occupational Safety'[YEAR]),'Occupational Safety'[Week]=WEEKNUM(TODAY(),1)-1))

5 Replies

  • deevaker's avatar
    deevaker
    Resolver I
    6 years ago

    First measure looks correct. Hope the relationship between your tables are fine.

     

    In second table, look like you need to use >= instead of = while doing filter.

    LastWeek = CALCULATE(SUM('Occupational Safety'[Value]),filter(ALL('Occupational Safety'[Week]),'Occupational Safety'[Week]>=WEEKNUM(TODAY(),1)-1))

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Thanks, 

      But I tried it but it didn't work. 

      • deevaker's avatar
        deevaker
        Resolver I
        6 years ago

        Shall we check. you can ping me on skype - deevaker1

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      deevaker  Could you look at my Dax Measure? do all columns have to reference the same table?

       

      LastWeek = CALCULATE(COUNT('SSRS_MissionServices_ActivitesDetail_view'[ActivityID]), 'dimDate'[CalendarYear]),'dimDate'[ISOWeekNumber]=WEEKNUM(TODAY(),1)-1))