Forum Discussion

i820017's avatar
i820017
Resolver II
4 years ago
Solved

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?    
Need Help
  • HotChilli's avatar
    HotChilli
    4 years ago

    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.

HotChilli's avatar
HotChilli
Community Champion
4 years ago

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