https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Take-2-days-off-date-if-Saturday-or-Sunday/m-p/4116149#M163401 <P>Anonymous</LI-USER>&nbsp;Try:</P> <LI-CODE lang="markup">Last Work Day = IF('Finance Budgets'[Day Name]="Saturday" || "Sunday", ( 'Finance Budgets'[Budget Date] -2 ) * 1., 'Finance Budgets'[Budget Date])</LI-CODE> Fri, 23 Aug 2024 16:22:42 GMT Greg_Deckler 2024-08-23T16:22:42Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Take-2-days-off-date-if-Saturday-or-Sunday/m-p/4116138#M163400 <P>Hi I have a table with dates that only show the last day of the month but I need the values in this table to show up in a visual that uses dates that only have weekdays in them. Essentially I just need to create a date column&nbsp; that takes 2 days off the given date if the day of the week name is Saturday or Sunday. This is the formula I am using but its not working. Any help would be great! tHANKS!<BR /><BR /></P><DIV><DIV><SPAN>Last Work Day = </SPAN><SPAN>IF</SPAN><SPAN>('Finance Budgets'[Day Name]=</SPAN><SPAN>"Saturday" || "Sunday"</SPAN><SPAN>, (</SPAN><SPAN>DATEADD</SPAN><SPAN>('Finance Budgets'[Budget Date], -</SPAN><SPAN>2</SPAN><SPAN> , DAY)), 'Finance Budgets'[Budget Date])</SPAN></DIV></DIV> Fri, 23 Aug 2024 16:17:52 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Take-2-days-off-date-if-Saturday-or-Sunday/m-p/4116138#M163400 Anonymous 2024-08-23T16:17:52Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Take-2-days-off-date-if-Saturday-or-Sunday/m-p/4116149#M163401 <P>Anonymous</LI-USER>&nbsp;Try:</P> <LI-CODE lang="markup">Last Work Day = IF('Finance Budgets'[Day Name]="Saturday" || "Sunday", ( 'Finance Budgets'[Budget Date] -2 ) * 1., 'Finance Budgets'[Budget Date])</LI-CODE> Fri, 23 Aug 2024 16:22:42 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Take-2-days-off-date-if-Saturday-or-Sunday/m-p/4116149#M163401 Greg_Deckler 2024-08-23T16:22:42Z