topic Re: Last week Dax in DAX Commands and Tips

Last week Dax

Anonymous — Wed, 18 Sep 2019 08:56:52 GMT

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,

Re: Last week Dax

deevaker — Wed, 18 Sep 2019 14:29:50 GMT

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))

Re: Last week Dax

Anonymous — Wed, 18 Sep 2019 14:47:07 GMT

Thanks,

But I tried it but it didn't work.

Re: Last week Dax

deevaker — Wed, 18 Sep 2019 14:58:05 GMT

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

Re: Last week Dax

Anonymous — Thu, 19 Sep 2019 08:10:11 GMT

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))

Re: Last week Dax

Anonymous — Mon, 29 Nov 2021 00:39:58 GMT

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))