Forum Discussion
Between two dates
Hello, I have a column with date of begning and a column with a date of end. I would like to create a report where I can see depending of the quarter of the years how many row are between those ...
Anonymous , Using independent date table
new measure =
var _max = maxx(allselected(Date1),Date1[Date])
var _min = mainx(allselected(Date1),Date1[Date])
returncalculate(count(Table[case]), filter(Table, Table[Start_date] <= _max && table[EndDate] >=_min))
Also, check
Anonymous , Using independent date table
new measure =
var _max = maxx(allselected(Date1),Date1[Date])
var _min = mainx(allselected(Date1),Date1[Date])
return
calculate(count(Table[case]), filter(Table, Table[Start_date] <= _max && table[EndDate] >=_min))
Also, check
Thank you!