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" ) )
User | Count |
---|---|
98 | |
90 | |
84 | |
71 | |
67 |
User | Count |
---|---|
114 | |
103 | |
100 | |
72 | |
64 |