Previous month Not working for me

[netanel]

Hey All!

A bit of a weird problem
In a lot of projects I did a month less last month
The formula works great
Just here it does not work for me.

I have a FACT table and a DIM DATE table
that's it
And the Measure are:

Count Person Num = DISTINCTCOUNT('Data HC'[Person Number])   

(Which brings me to the number of people in the organization)

Previous month = CALCULATE([Count Person Num],DATEADD('Date'[Date],-1,MONTH))

(That should bring me the previous month but something is wrong with it)

Can you understand why?
She's currently bringing me the same number for the current month

Thanks!

[CNENFRNL · Accepted solution]

Sounds like only a rookie's mistake. Even if your measure uses previous month as date filter, any other existing date filters in the viz/matrix need to be taken into consideration.

[netanel]

@CNENFRNL 

shame on me

I played so much with the data
That I did not look at this little thing

Thanks!

[mh2587]

try this instead of dateadd:
PREVIOUSMONTH(<dates>)

[netanel]

@mh2587 

its bring me blank
But I really want to know why it's not going my way
I'm sure I'll find something