Problem with dates

[GMichaud]

Hello community!

I just noticed a strange behavior in the segment vizual if I use dates with various functions of this vizual. Here are two examples :

From what I can see, the ranges of dates are the same. How come the result that is shown in the card is different? Anybody has an idea on that?

Thanks!

[Kumail]

Hello @GMichaud 

If you could send sample .pbix that demonstrate what you are looking to get. It would really help providing you a quick solution.

You can send the sample .pbix file by adding it to your drive or dropbox and add the link here.

Regards
Kumail Raza

[GMichaud]

@Kumail sadly, that won't be possible. I can tell you that the card shows the result of a calculated measure that uses the COUNTROWS function though. Does that help narrow it down?

[v-deddai1-msft]

Hi @GMichaud ,

Did you have a date table in your data model? Would you please try to create a date table and create an one to many relationship between date table and fact table and use the same date column for two slicers?

It works well based on my test, there could be some other filter on your card visual. It's better that you can share us the sample pbix with the issue.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai

[GMichaud]

@v-deddai1-msft 

Indeed, I have a date table and it is marked as such. Would it be possible that DAX reacts as SQL does sometimes when you use something like this :
date >= '2021-07-01' AND date <= '2021-07-07' instead of date >= '2021-07-01T00:00:00.000' AND date <= '2021-07-01T23:59:59.999'

I've experienced some strange behaviors in the past with this also.

Thanks!

[v-deddai1-msft]

Hi @GMichaud ,

It depends on what's the field you used to connect to date table. Is it a datetime type or date type? 

It's better that you can share us the sample pbix with the issue.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai