This content has been marked as final.
Show 2 replies

1. Re: Date Calculation: Daily Weekday Data, Need to Only Select First Entry for Each Month
Tom W Jun 13, 2016 4:49 PM (in response to John T)There's a couple of ways to solve for this, here's one approach using Level of Detail calculations.
I've created a level of detail calculation to figure out when the first weekday is of each month;
{FIXED [mmmyy] : MIN(if DATEPART('weekday',[Order Date])>1 and DATEPART('weekday',[Order Date])<7 then [Order Date] end )}
Then I create a calculated field to sum the sales values on those dates only;
sum(if [Order Date]=[FirstWeekday] then [Sales] end)
I'm using a helper field called mmmyy to allow me to do a FIXED LOD calculation at the Month and Year level.

LODFirstWeekday.twbx 1.2 MB


2. Re: Date Calculation: Daily Weekday Data, Need to Only Select First Entry for Each Month
John T Jun 14, 2016 4:40 PM (in response to Tom W)Thanks Tom, worked great!