Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I am trying to calculate as sum of the WeeklyPlan column with only data that has a year of 2017 and a specified week num. Below is the formula I am using:
LastWeekPlan = CALCULATE(sum('Weekly'[Weekly Plan]),Weekly[Year]=2017,Weekly[WeekNum]=(WEEKNUM(2/13/2017,1)))
The formula works if I add a stagnant number in the Weekly[WeekNum]=... boolean, but when I add the WEEKNUM expression, the formula doesn not work. I will eventually be replacing the date with today() expression.
Any ideas why my logic will not work?
Solved! Go to Solution.
Use WEEKNUM(DATE(2017,2,13),1)
Hi,
Could you please tell me if your problem is solved? You can mark the right answer to help others if it's convenient for you.
Best Regards!
Dale
Use WEEKNUM(DATE(2017,2,13),1)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |