Anonymous's avatar
Anonymous
Not applicable
1 year ago
Status:
New

Fix the Date function in DAX

Below is an issue a fair few people are facing. I'm not sure it's been raised so i'm raising / re-raising.   All be-it there's cira 16 replies, maybe more people are facing this issue? Many of us...
Data Modeling
Versus's avatar
Versus
New Member
1 year ago

I give an example. This works fine: 

Companies (L28D) = 
CALCULATE(
    DISTINCTCOUNT(companies[id]),
    DATEVALUE(companies[created_at]) >= TODAY() - 28 &&
    DATEVALUE(companies[created_at]) < TODAY()
)

but this doesn't:

Companies2 (L28D) = 
CALCULATE(
    DISTINCTCOUNT(companies[id]),
    companies[created_at] >= TODAY() - 28 &&
    companies[created_at] < TODAY()
)

 

The field is of type `date`.

Completed Ideas