Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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.
Solved! Go to 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))
@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))
User | Count |
---|---|
17 | |
14 | |
14 | |
13 | |
12 |
User | Count |
---|---|
19 | |
15 | |
15 | |
10 | |
9 |