Forum Discussion
dmbd1904
Helper III
4 years agoCircular Dependency
Hi I'm really struggling with this one. Can any one help Standing Time = VAR Location = COR_DepthRelatedExploratoryInformation[LocationDetails] VAR Startdate = COR_DepthRelatedExplo...
amitchandak
Super User
4 years agodmbd1904 , Try like. I am assuming you are creating a new column
Standing Time = VAR Location = COR_DepthRelatedExploratoryInformation[LocationDetails]
VAR Startdate = COR_DepthRelatedExploratoryInformation[DateTimeStart]
VAR Enddate = COR_DepthRelatedExploratoryInformation[DateTimeEnd]
RETURN CALCULATE(SUM(COR_TimeRelatedRemarksLocation[Working Hour Duration]),Filter(COR_TimeRelatedRemarksLocation ,COR_ProgressByTime[LocationDetails]=Location && COR_TimeRelatedRemarksLocation[DateTimeStart]>=Startdate && COR_TimeRelatedRemarksLocation[DateTimeEnd]<=Enddate) )