Forum Discussion
How to use dates between on 2 dates
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
5 Replies
- some_bih
Community Champion
Hi dabeans518 some of your measure/s now working properly or...? If it is about measure, please share measure definition and other details.
Sorry I forgot to put the measure. Let me edit my question
- some_bih
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.
