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)
johnt75
Super User
Super UserI think you can use
Date is active =
VAR StartDate =
SELECTEDVALUE ( WorkScheduleWorkSchedule[Date] )
VAR EndDate =
SELECTEDVALUE ( WorkSchedule[Expected Finish] )
VAR CurrentDate =
SELECTEDVALUE ( 'Date'[Date] )
VAR Result =
IF ( StartDate <= CurrentDate && CurrentDate <= EndDate, 1 )
RETURN
Result
Its counting for all dates
speedrampsSorry 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)Perfect, Thanks.
I have a doubt, without relation between the two tables, how is the matrix visual able determine the relation between the coulmn and Rows.
Thanks in Advance
