Trouble getting a count in last 30 days for visual

[Anonymous]

@Link to members, content

I am having trouble counting the number of IDs in my visual for the last 30 days.  I have the correct counts on a card, but cannot create the measure.  The measure is as follows: 

CCD Last 30 = CALCULATE (

    Count ( 'virtbk notes'[Id] ),

    DATESINPERIOD ( MAX('virtbk notes'[DateTimeUtc]), MAX ( 'virtbk notes'[DateTimeUtc] ), -30, DAY )

)

Here are my cards, I need measures that will calculate the number of IDs in the last 30 days

Any help would be greatly appreciated. 

[imnewpbiuser568]

Last 30 Days =

var maxdate = MAX(Date_data[Date])

return

CALCULATE(

    COUNT(Customer_data[Customer ID]),

    DATESINPERIOD(Date_data[Date],maxdate,-30,DAY)
)

[VijayP]

@Anonymous  IF you can provide some sample data I can help !

[Anonymous · Accepted solution]

ID	Name	Date	Note
45612	Jane Doe	12/8/2023	CCD - In process
12548	Mark Dane	12/9/2023	CCD - Settled
06458	Shelly Craft	1/2/2024	CCD - Settled
15487	Harold Dunn	11/30/2023	CCD In Process
48757	Mark Twain	12/9/2023	CCD - In Process

[Anonymous]

@VijayP 

I need counts in the last 30 days for all and I need another measure for count in last 30 days where the note type is SETTLED

[Anonymous]

Ok I will send sample data over shortly, i have to create it

[VijayP]

@Anonymous 

DATESINPERIOD ( [DAtetimeutc], MAX ( 'virtbk notes'[DateTimeUtc] ), -30, DAY )

try this.

[VijayP]

@Anonymous If my answer is helping you please mark it as solution!

[Anonymous]

Vijay, 

I am getting this error when trying your formula

[Ahmedx]

you added an extra parenthesis

[Anonymous]

Removed the Paren and still get this error

[Ahmedx]

you must have a food calendar table with no repeating dates and no space