Getting the last working day before today

[mo1988]

Hi,

In my powerbi report, I am trying to flag as the latest working day as 1 and other days as 0.

Working Days are (Monday -> Friday)
Attached is a sample example of what I am trying to achieve.

Please help - thanks.

[v-yangliu-msft · Accepted solution]

Hi  @mo1988 ,

Here are the steps you can follow：

1. Create measure.

Measure =
var _today=TODAY()
var _week=WEEKDAY(MAX('Date'[Date]),2)
return
MAXX(
    FILTER(ALL('Date'),
    'Date'[Date]<_today&&NOT( _week) in {6,7}),'Date'[Date])

2. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[amitchandak]

@mo1988 ,

maxx(filter(allselected(Date), date[Date] < date[Date] && weeknum(Date[Date],2) <6) , Date[Date])

Also, check

Power BI Workday vs Last Workday- https://youtu.be/MkYLT_GYIbM