Measure for count of last 7 days

[jsabo]

I am looking for DAX that will count the number of Visits for the given time frame (today looking 7 days back). I have tried the below, but it is giving me an error regarding duplicate dates. Any ideas?

Requested Last 7 Days = CALCULATE (
        COUNT ( 'Active Assignments'[assignment_seq] ),
        DATESINPERIOD ( 'Active Assignments'[date_requested], LASTDATE ( 'Active Assignments'[date_requested] ), -7, DAY )
    )

[Nischal]

Requested Last 7 Days = CALCULATE (
DISTINCTCOUNT ( survey_reports[responseId] ),
DATESINPERIOD ( date1[Date] ,LASTDATE(date1[Date] ), -7, DAY )
)

it's giving me a blank instead of value

[Nischal]

There is some error in this method, I should get 0 instead I am getting 3......

week=CALCULATE(DISTINCTCOUNT(survey_reports[mobile]),DATESINPERIOD(survey_reports[date],LASTDATE(survey_reports[date]),-7,DAY))

[MrPowerBIPro]

@jsabo That's a Good news.

See this link to found more:

https://community.powerbi.com/t5/Desktop/DATESBETWEEN-Date-and-Time-Field/td-p/17462

Regards

Mostafa

[MrPowerBIPro]

Can you copy the error here?

[jsabo · Accepted solution]

@MrPowerBIPro, thanks. Below is the error:

Error Message:
MdxScript(Model) (3, 9) Calculation error in measure 'Active Assignments'[Requested Last 7 Days]: A date column containing duplicate dates was specified in the call to function 'DATESINPERIOD'. This is not supported.

Again, I just wanted to count the number of Assignment IDs (assignment_seq) opened in the last 7 days (using the date_requested field).

EDIT: was overthinking it, found a solution:

Requested Last 7 Days = CALCULATE(
        DISTINCTCOUNT('Active Assignments'[assignment_seq]),
        FILTER(ALL('Active Assignments'), 'Active Assignments'[date_requested] >= TODAY()-7)
)