Problem with dates

GMichaud · ‎07-07-2021

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 · ‎07-07-2021

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 · ‎07-07-2021

@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 · ‎07-09-2021

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 · ‎07-12-2021

@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!