Solved: Filter Data Date Column into weekends

rocciajb36 · ‎03-11-2022

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 · ‎03-11-2022

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

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview. ✨
️ November 12th-14th, 2024
 Online Event
Register Here

View solution in original post

amitchandak · ‎03-11-2022

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

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview. ✨
️ November 12th-14th, 2024
 Online Event
Register Here

Filter Data Date Column into weekends

Helpful resources

Fabric Community Update - November 2024

Be one of the first to start using Fabric Databases

Join us at the Microsoft Fabric Community Conference

Power BI Monthly Update - November 2024

Be one of the first to start using Fabric Databases.