Measure of date for a day before [Weekends Excluded]
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