Forum Discussion

Felipekard's avatar
Felipekard
Frequent Visitor
3 years ago
Solved

Last day dax

Morning everyone,   I has one calendar table, like this: Days: the days IS WORKDAY:  1 if is workday, 0 if isn't work day LAST WORKDAY: the workday -1    I need made this calculated column LAS...
  • johnt75's avatar
    johnt75
    3 years ago

    You could create a column like

    Last workday =
VAR CurrentDate = 'Date'[Date]
RETURN
    CALCULATE (
        MAX ( 'Date'[Date] ),
        REMOVEFILTERS ( 'Date' ),
        'Date'[Date] < CurrentDate,
        'Date'[Is working day] = 1
    )
johnt75's avatar
johnt75
Icon for Super User rankSuper User
3 years ago

You could create a column like

Last workday =
VAR CurrentDate = 'Date'[Date]
RETURN
    CALCULATE (
        MAX ( 'Date'[Date] ),
        REMOVEFILTERS ( 'Date' ),
        'Date'[Date] < CurrentDate,
        'Date'[Is working day] = 1
    )
Felipekard's avatar
Felipekard
Frequent Visitor
3 years ago

Works great! Thank you my friend.