Forum Discussion
DATESBETWEEN Issue
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?
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.
4 Replies
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
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.
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.
Thanks!!...Using Month and Year worked.
