Forum Discussion
Get the count between two date columns
I'm having a hard time wrapping my head around this. Each row has two date columns (start date and end date). If one row has a date starting 1/1/2023 and end date of 5/1/2023 then the time period...
I do have a start and end date columns and a date table. I applied what you showed but when inserted into the line graph, I get a single line with the value of 1.
Make sure to add your Table1 rows as legends in the chart (that way it will show a different color line for each one).
Also, try it on a matrix (Table1 x Calendar and this measure as Value) and you'll see it calculates the 1 and 0 as expected).