topic How to use dates between on 2 dates in DAX Commands and Tips

How to use dates between on 2 dates

dabeans518 — Fri, 30 Aug 2024 02:10:08 GMT

I have a table named fct_BINotes which has 2 columns named [JsonParameters.Start Date] and [JsonParameters.End Date]. And I have a date range filter that comes from a table named dim_Calendar with a column CalendarDate.

My problem is it's not filtering properly with the date.

The measure IsInDateRange checks if Start Date and End Date is between the Date Range

Both [JsonParameters.Start Date] and [JsonParameters.End Date] are connected to CalendarDate

I hope you can help me

Re: How to use dates between on 2 dates

some_bih — Thu, 29 Aug 2024 06:29:36 GMT

Hi dabeans518 some of your measure/s now working properly or...? If it is about measure, please share measure definition and other details.

Re: How to use dates between on 2 dates

dabeans518 — Thu, 29 Aug 2024 06:32:23 GMT

Sorry I forgot to put the measure. Let me edit my question

Re: How to use dates between on 2 dates

some_bih — Thu, 29 Aug 2024 08:37:33 GMT

Hi dabeans518 I really tried to understand your measure, still I do not understand it. It is mainly due to fact that measure firstly calculate min and max date on Calendar date and after that there are filter argument in CALCULATE for different combination min and max date.

In addition, I do not understand your part

Both [JsonParameters.Start Date] and [JsonParameters.Start Date] are connected to CalendarDate

is it some part typo here becuse Start Date is mentioned twice

I would like to understand what is your request.

I assume you want to calculate something like number of rows for some filter conditions, maybe in addition with not active table, but I need more details example input and expected output for that inputs to provide possible solutions.

Re: How to use dates between on 2 dates

dabeans518 — Fri, 30 Aug 2024 02:12:06 GMT

Sorry for the confusion, my goal on the measure is if the date range is in between the [JsonParameters.Start Date] and [JsonParameters.End Date], then it will return 1, else 0

Re: How to use dates between on 2 dates

some_bih — Fri, 30 Aug 2024 05:19:36 GMT

Hi dabeans518 no prob 🙂

Please provide example data with inputs and expected output as measure should be precise