Check date if its within StartDate and EndDate

[Anonymous]

Hi All,

I have orders with StartDate and EndDate. and i have a filter "Month Year". 

When i select a value in MonthYear Filter, for example "August 2020",  i need to check if Aug 2020 is between the startdate and the enddate and provide orders only meet this criteria. 

Any help in getting this please.

[VijayP]

@Anonymous 

Calculate(Measure,filter(all(datestable),datesbetween(datestable[dates], min(selectedvaluue(dates[date),max(selectedvalue(dates[date])

Please try this Formula Measure and let me know

[Anonymous]

@VijayP  Hi Vijay,

Could you please elaborate more on your solution.

I have "month year" in a seperate table and the startdate and enddate is in one table. 

I need to compare if the value selected in "monthyear" is between this startdate and enddate.

[Anonymous]

Hi all,

I think my question is very simple, but somehow im unable to figure it out and not able to find relevant answers in powerbi forum.

Please please help me with this.

[Greg_Deckler]

@Anonymous Re-reading post, you need a Complex Selector. https://community.powerbi.com/t5/Quick-Measures-Gallery/The-Complex-Selector/m-p/1116633#M534

The trick is to use ALL in order to break filter context and then determine if each item is within range. It is nex to impossible to be more specific without sample data as text and expected output.

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

[Greg_Deckler]

@Anonymous Are you looking for something like LookupValue Range?

https://community.powerbi.com/t5/Quick-Measures-Gallery/LOOKUPVALUE-Range/m-p/974201#M430

[Anonymous]

@Greg_Deckler  Thanks Greg.  

I need to check if the date i have selected in the filter is within the startdate and the enddate and put orderamount next to it if it matches the criteria.

I'm bit confused with the lookupvalue range solution that you have implemented. Would you mind explaining how i can modify to my scenario?