Unable to correctly filter records using start and end date

[Anonymous]

Hi, I'm trying to create a measure where if a date falls within start and end date fields, it's a match else it's not.
Here's my data

As you can see here, some of the fields marked True in the last column, should be marked as false because they fall outside of the date range.

This is the DAX code I'm using.

_A Date between IterStart IterEnd =

IF (

SELECTEDVALUE (

'UniqueSprintSchedule'[IterationStartDate] ) >= MAX ( 'WIP Data'[Epic Actual End Date])

&& SELECTEDVALUE ( 'UniqueSprintSchedule'[IterationEndDate] ) <= MAX ( 'WIP Data'[Epic Actual End Date] ),

TRUE(),FALSE()

)

What am i doing wrong? 

[Anonymous · Accepted solution]

Hi Sparta.  I'll have to stop at this point.  Due to the limitations I have, I'll be unable to proceed any further on this question. Thanks for the attempt and I appreciate it.

[v-yanjiang-msft · Accepted solution]

Hi @Anonymous ,

According to your description, in your formula, the symbol doesn't seem right. The IterationStartDate should <= Epic Actual End Date and the IterationEndDate should >= Epic Actual End Date.

I create a sample and it can get the correct result after modify the symbol.

I attach my sample below for reference.

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-yanjiang-msft · Accepted solution]

Hi @Anonymous ,

According to your description, in your formula, the symbol doesn't seem right. The IterationStartDate should <= Epic Actual End Date and the IterationEndDate should >= Epic Actual End Date.

I create a sample and it can get the correct result after modify the symbol.

I attach my sample below for reference.

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous · Accepted solution]

Thank you very much. I see where I made what some might call a "Stupid" mistake.

I appreciate the response!

[Anonymous · Accepted solution]

Hi Sparta.  I'll have to stop at this point.  Due to the limitations I have, I'll be unable to proceed any further on this question. Thanks for the attempt and I appreciate it.

[SpartaBI]

@Anonymous ok, sorry I couldn't help here

[Anonymous]

I wish i could but at this time, I'm unable to do it. But I appreciate the input. I just can't go past providing this much....

[Anonymous]

I'm sorry, it's not possible at time...I'll have to pass on this question and thank you for your attempt.

[SpartaBI]

Ok 🙂 Sorry I couldn't help more. 
P.S.
Check out my showcase report - got some high level stuff there 🙂
https://community.powerbi.com/t5/Data-Stories-Gallery/SpartaBI-Feat-Contoso-100K/td-p/2449543
Give it a thumbs up if you liked it 🙂

[Anonymous]

Hi Sparta. I wish i could but can't.  Having a copy of the actual data, is the best to describe a problem.
I'll have to see what I can do. Thanks for the attempt.

[SpartaBI]

@Anonymous your columns have similar names, want to be sure you don't have a typo 🙂
What exactly do you want to be between what?
Also, in the screenshut you send, all of the columns in the table except the last one are columns or are some of them measures? Best if you could just share the file

[Anonymous]

Thanks for your response. Unfortunately i can't submit the tables, i can only describe what I'm trying to do.
Here's a screen print that might provide enough information?

The data model of the two tables

[SpartaBI]

@Anonymous Still didn't understand. Would be great if you could create a sample PBIX with few rows and share it.