Forum Discussion
How to use dates between on 2 dates
Community ChampionHi 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.
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
- some_bih
Hi dabeans518 no prob 🙂
Please provide example data with inputs and expected output as measure should be precise