Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 |
---|---|
140 | |
113 | |
104 | |
76 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |