topic Re: Filter Data Date Column into weekends in DAX Commands and Tips

Filter Data Date Column into weekends

Anonymous — Fri, 11 Mar 2022 15:40:53 GMT

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.

Re: Filter Data Date Column into weekends

amitchandak — Fri, 11 Mar 2022 15:51:12 GMT

Anonymous , 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))