Forum Discussion
Last weekday Dax formula
I have a sales report that I report. On Monday's, I want the report to show sales for Friday, not Sunday. We are close Saturday and Sunday. So my simple sales for now()-1 does not work. Please help
Greg_Deckler
Community Champion
Community ChampionCan't do much without the data you have, are you using a date table? One way would be to create a new column that would be something like:
LastWeekDay = IF(WEEKDAY([Date])=6,[Date]-3,[Date]-1)
date table?
I have two columns named "sales" and "ship_date". I put sales in a box that displays a total of all sales and now I want to narrow it down to "last business day" sales. Do I pull over "ship_date" as a filter or a measure?
I have two columns named "sales" and "ship_date". I put sales in a box that displays a total of all sales and now I want to narrow it down to "last business day" sales. Do I pull over "ship_date" as a filter or a measure?