Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi all,
Pls help me to create a WorkingdayID1 or WorkingdayID2 column as below.
Solved! Go to Solution.
Hi @daominhtri
Try this for your column:
WorkingDayID2 = COUNTROWS ( FILTER ( Table1; Table1[Date] <= EARLIER ( Table1[Date] ) && Table1[DayType] = "Workingday" ) )
@daominhtri Create following calculation columns. Please see the attached file for your reference.
Working Day ID1 = COUNTROWS ( FILTER ( Sheet1, Sheet1[Date] <= EARLIER ( Sheet1[Date] ) && Sheet1[Type] = "Working" ) )
Working Day ID2 = IF(Sheet1[Type]="Working",Sheet1[Working Day ID1],BLANK())
@daominhtri Create following calculation columns. Please see the attached file for your reference.
Working Day ID1 = COUNTROWS ( FILTER ( Sheet1, Sheet1[Date] <= EARLIER ( Sheet1[Date] ) && Sheet1[Type] = "Working" ) )
Working Day ID2 = IF(Sheet1[Type]="Working",Sheet1[Working Day ID1],BLANK())
Hi @daominhtri
Try this for your column:
WorkingDayID2 = COUNTROWS ( FILTER ( Table1; Table1[Date] <= EARLIER ( Table1[Date] ) && Table1[DayType] = "Workingday" ) )