Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Filter Data Date Column into weekends

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's avatar
    amitchandak
    4 years ago

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

amitchandak's avatar
amitchandak
Super User
4 years ago

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