topic How to exclude the last seven days in Dax in DAX Commands and Tips

How to exclude the last seven days in Dax

OhLookAnError — Tue, 28 Feb 2023 14:31:09 GMT

is there a way to add to this measure to exclude anything in the last seve days?

I tried to filter my data in power query to exclude the last seven days but there doesn't seem to be a way...

Revenue per Hour =

Var Hours = Calculate(SUM(tblEnvPerManHr_Summary[TotalHrs]),

DATESINPERIOD(tblEnvPerManHr_Summary[ReportDate],

LASTDATE(tblEnvPerManHr_Summary[ReportDate]),-30,DAY))

VAR Revenue = Calculate(SUM(tblEnvPerManHr_Summary[Revenue]),

DATESINPERIOD(tblEnvPerManHr_Summary[ReportDate],

LASTDATE(tblEnvPerManHr_Summary[ReportDate]),-30,DAY))

RETURN

Divide(Revenue,Hours,0)

andhiii079845 — Tue, 28 Feb 2023 15:26:31 GMT

Perhaps try dateadd(tblEnvPerManHr_Summary[ReportDate],-7,day) ?

OhLookAnError — Tue, 28 Feb 2023 16:06:49 GMT

I've tried to add that to the measure in a couple different spots but cant get it to work. Where would I add that in?

andhiii079845 — Tue, 28 Feb 2023 16:11:14 GMT

Var Hours = Calculate(SUM(tblEnvPerManHr_Summary[TotalHrs]),

DATESINPERIOD(tblEnvPerManHr_Summary[ReportDate],

LASTDATE(tblEnvPerManHr_Summary[ReportDate]),-30,DAY))

Var Hours = Calculate(SUM(tblEnvPerManHr_Summary[TotalHrs]),

DATESINPERIOD(dateadd(tblEnvPerManHr_Summary[ReportDate],-7,day),

LASTDATE(tblEnvPerManHr_Summary[ReportDate]),-30,DAY))

OhLookAnError — Tue, 28 Feb 2023 16:38:55 GMT

This is what I'm seeing for that:

andhiii079845 — Tue, 28 Feb 2023 16:43:27 GMT

Thank you. Perhaps try to add a VAR for your date

VAR 7day = dateadd(tblEnvPerManHr_Summary[ReportDate],-7,day)

And use it in your measure later?