Count Date Rows in Last Month

[Anonymous]

Hi All,

I have a column called 'Dates' this column shows various dates. 

Please can you show me the DAX to count the number of rows with dates in the last month?

Many thanks,

E

[Anonymous]

@Anonymous 

Try use this measure, you can use today's month and then -1.

Erected in Past Month = CALCULATE(DISTINCTCOUNT('Table'[Date]),MONTH('Table'[Date])=MONTH(TODAY())-1)

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

[timg]

Hi Serdet,

You can use this: 

CountDaysLastMonth = CALCULATE(DISTINCTCOUNT(DimDate[Date]), PREVIOUSMONTH(DimDate[Date]))

best regards,

Tim

[Anonymous]

Hi Tim

I have tried your measure and have received 'blank' in my card visual. I am using the measure by replacing dimdate[date] with my date column. Is this the correct approach?

Thanks 

E

[timg]

Hi Serdet,

Yes that's correct. Could you perhaps share your formula and a sample of your date table data?

regards,

Tim

[Anonymous · Accepted solution]

Hi Tim,

The formula is shown below;

Erected in Past Month = CALCULATE(DISTINCTCOUNT('Standing Scaffold Data'[ErCompleteDate]), PREVIOUSMONTH('Standing Scaffold Data'[ErCompleteDate]) )

Sample Data:

ErCompleteDate

01/01/2020

01/01/2021

01/02/2021

07/09/2019

etc

Regards,

E