Count until Last Saturday of the month

[eshanpacheriwal]

Hi all
I was lookin got get a count of a data until last saturday of the month. 
Is there any dax available for it?

[isabella]

Hi @eshanpacheriwal 

My approach is to first get the date of the last Saturday of each month, and then do a count operation

My test table:

Create a column  represents the first day of the next month

FirstDayOfNextMonth = DATE(YEAR([DATE]),MONTH([DATE])+1,1)

Then create a coumn represents the lastSaturday of this month

LastSaturday = DATEADD('TableDEMO'[FirstDayOfNextMonth].[Date],-WEEKDAY([FirstDayOfNextMonth]),DAY)

Now the table looks like this :

Then I create a column to count  

Column = CALCULATE(COUNT(TableDEMO[DATE]),FILTER(ALL(TableDEMO),MONTH([DATE])=MONTH(EARLIER(TableDEMO[DATE])) && [DATE]<=EARLIER(TableDEMO[LastSaturday])))

Now the table looks like this :

Best Regards,

Community Support Team _Isabella

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Fowmy]

@eshanpacheriwal 

Following measure should return the total sales up to last Saturday, adjust it to suit your data model:

Sales Till Last Sat = 
VAR __LAST_SAT = calculate( maxx( FILTER ( all('Date'[Date]) , WEEKDAY ('Date'[Date]) = 5) , 'Date'[Date]))
VAR __DATE_RANGE =  FILTER ( ALL( 'Date'[Date]), 'Date'[Date] <= __LAST_SAT )
VAR __RESULT = CALCULATE ( [Sales Amount] ,  __DATE_RANGE)
RETURN 
__RESULT

[amirabedhiafi]

https://community.powerbi.com/t5/Power-Query/Last-Saturday-of-the-Month/td-p/2008520