Measure of date for a day before [Weekends Excluded]

[Nishlija995]

Hello all,

I have a simple DAX column that should adjust the date when data is written.

date_adjustment = FORMAT(table_name[Created],"dd.mm"

Since I am writing data today for day before I tried to get the date by adding

date_adjustment = FORMAT(table_name[Created],"dd.mm" - 1

Problem with this is the data written on monday, will show the date of Sunday instead of Friday.

For example 01/16/2023 was Monday and this data is for Friday 01/13/2023 and not Sunday 01/15/2023.

How can I make it always ignoring weekends and all data from last Monday to be asigned to last Friday?

Thanks

[FreemanZ]

hi @Nishlija995 

try to write the column like:

date_adjustment =
VAR _date = [Created]
RETURN 
MAXX(
    FILTER(
        table_name,
        table_name[Created] <_date
            && NOT WEEKDAY(table_name[Created]) IN {1,7}
    ),
    table_name[Created]
)

[Nishlija995]

Hello @FreemanZ , thanks for fast response.

Unfortunatly this is not something I was looking for. Here is the screenshot.

This is the difference, on the right side is your formula. I need for all values to slip one day before. So 16th should be empty and this data should be written to 13th, 13th should go to 12th, 12th to 11th, etc. And also, weekends should not be visible in chart since they are empty.