Forum Discussion
Calculate count between two dates
Hi , I have three tables fact table, sprint table. Fac Table Fact ID BuildStatDate TriageStartDate 121 10-11-2023 11-11-2023 122 11-12-2023 12-11-2023 123 12-12-202...
Hi Anonymous
Would a measure like this help?
Build = VAR _SoM = SELECTEDVALUE( 'Sprint'[Start] ) VAR _EoM = SELECTEDVALUE( 'Sprint'[End] ) VAR _Count = COUNTROWS( FILTER( ALLSELECTED( 'FactTable'[BuildStatDate] ), 'FactTable'[BuildStatDate] >= _SoM && 'FactTable'[BuildStatDate] <= _EoM ) ) RETURN _CountCounts for Build and Triage.pbix
Hi Anonymous
Would a measure like this help?
Build =
VAR _SoM = SELECTEDVALUE( 'Sprint'[Start] )
VAR _EoM = SELECTEDVALUE( 'Sprint'[End] )
VAR _Count =
COUNTROWS(
FILTER(
ALLSELECTED( 'FactTable'[BuildStatDate] ),
'FactTable'[BuildStatDate] >= _SoM
&& 'FactTable'[BuildStatDate] <= _EoM
)
)
RETURN
_Count
Counts for Build and Triage.pbix
Thanks , just wanted to check how we can implment this using calendar table.Because i need calendar table which filter both Build and Triage.
Hi,
For all practical purposes, the Sprint table is the Calendar table. It should just have 3 columns - Date, Month name and Month number. Sort the Month name by the Month number. there shouldnot be a relationship between Calendar Table and the other 2 tables.
Understood. Thanks for the reply!!
