Forum Discussion

daominhtri's avatar
daominhtri
Frequent Visitor
7 years ago
Solved

Create WorkingdayID column

Hi all, Pls help me to create a WorkingdayID1 or WorkingdayID2 column as below.  
AlB's avatar
AlB
Icon for Community Champion rankCommunity Champion
7 years ago

Hi daominhtri

 

Try this for your column:

 

WorkingDayID2 =
COUNTROWS (
    FILTER (
        Table1;
        Table1[Date] <= EARLIER ( Table1[Date] ) && Table1[DayType] = "Workingday"
    )
)