Forum Discussion
Solved
Marking Dates In Between Two Dates (for Displaying Time Spread in days of an activity)
I have two tables Table 1 : WorkSchedule Activity Date Expected Finish Client A 01/01/2025 04/01/2025 SS A 01/01/2025 3/01/2025 DD C 05/01/2...
Sorry for tytping mistake.
I have corrrected it
Answer = VAR mydate = SELECTEDVALUE('Calendar'[Date]) VAR tempfile = FILTER(yourdata, mydate >= yourdata[Start date] && mydate <= yourdata[Finish date] ) RETURN COUNTROWS(tempfile)
speedramps
Super User
Super UserTry this ....
Remove the Calendar relationship.
)Calendar relations should not be used forstart to finish date sceranrios because the rleationshiop will only work on one date and not the dates inbetween)
Create measure (using you own table and column names)
Answer =
VAR mydate = SELECTEDVALUE('Calendar'[Date])
VAR tempfile =
FILTER(yourdata,
mydate >= yourdata[Start date] &&
mydate <= yourdata[Finish date]
)
RETURN
COUNTROWS(yourdata)
Add a matric visual to your reports
Please click the [accept solution] and thumbs up button.
At the very least click the thumbs up button to show your appreciation.
Thank you. 😀
Hi,
In your A -SS ends on 05th , but in your result it is counted for days after that also.
I also tested your approach, but it is giving Wrong output