Forum Discussion
Solved
Dax Question re: Datesbetween
I have a question as to why these measures are giving me different results because it does not make sense to me. I have a Table, we'll call products. There is a column called ActualDate. The Min...
Hmm. I cannot seem to replicate this. That being said, the syntax seems weird to me. My suspician is that there is something wonky going on in your relationship between the tables. For example, I was able to replicate this when the things that I was counting did not have matching relationships in the dimDate table. So, I might have 8 items, but I only had 6 dates in my dimDate table. So, do all of your ActualDates match up with all of the dates in your dimDate table?
Would be interested if you could post some sample data in a table that could be used to replicate this issue.
What results are you seeing from these?
From the first one, without dates, I'm getting about 300,000 results. When i use the datesbetween its going down to 34,000 which doesn't make sense to me because all rows are between those dates.