Filter Data Date Column into weekends

[rocciajb36]

How do i use DAX to take a column with a date in it and populate a column with a weekend date? I want to be able to filter my data which all has dates into weekends by date.  

[amitchandak · Accepted solution]

@rocciajb36 , you can create a column like this and use that

new column

weekday flag = if(WEEKDAY([Date],2) <6,1,0)

measure

calculate(sum(Table[Value]), filter('Date', 'Date'[weekday flag] =1))