DATESBETWEEN Issue

[i820017]

I am creating a calculated column from 2 other columns in my app, and I am getting this error.

Why I am getting this error? and how can I fix it?

[HotChilli · Accepted solution]

Thanks, very succinct answers.  I'm not used to it.

Right, so DATESBETWEEN returns a column of dates and that's why it is used with a Dates table (not  a Fact table).  It's also usually used with a measure not a column.

So, if we try and solve all issues here with DATESBETWEEN, I don't think we're going to achieve anything.

I think you are trying to test if the PTO_Calendar[End_date_repeat] is in the period of January 2022.  Is that right?

If so, you can remove the DATESBETWEEN and just use YEAR and MONTH functions to test.

Let me know.

[i820017]

Thanks!!...Using Month and Year worked.

[i820017]

Here are the answers to your questions:

1. PTO_Calendar[End_date_repeat] is a date column that contains duplicates.

2. PTO_Calendar is a Fact Table.

3. I just switched 2nd and 3rd parameters to date expressions as seen below.

[HotChilli]

Is PTO_Calendar[End_date_repeat] a date column which contains duplicates?

--

Also, DAX time intelligence functions work best with a Dates table which contains a column of unique dates.  Is that what PTO_Calendar is, or is that a Fact table?

And, finally, the 2nd and 3rd parameters passed to DATESBETWEEN should be date expressions.  These ones look like strings