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.
Hi, I'm trying to return the date of the previous Sunday based on the date selected by the user.
I have this measure which works based on today; TODAY() - WEEKDAY(TODAY(),1)+1
But if I swap out the today() with selectedvalue or even a variable with the selected date stored in I get a random date of 31/12/1899 so I assume it has something to do with not recognising my dates as dates? In any case everything I have tried so far hasn't worked.
What am I doing wrong, anyone?
Thanks,
Ben
Solved! Go to Solution.
@Ben81 , As a column
[Date]- WEEKDAY([Date], 1)+1
As a measure
selectedvalue(Date[Date]) - WEEKDAY(selectedvalue(Date[Date]) , 1)+1
@Ben81 , As a column
[Date]- WEEKDAY([Date], 1)+1
As a measure
selectedvalue(Date[Date]) - WEEKDAY(selectedvalue(Date[Date]) , 1)+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 |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |