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 Folks, I have date column in my report based on date column when user selecting any date i want to display last Monday date on my report. Can you please help me on DAX. For example today is 23rd nov tuesday when user selecting on 23/11/2021 Tuesday i want to get date last monday(15/11/2021) same as for all. When ever user selecting any date date on middle of day i want to display always last monday.
Solved! Go to Solution.
Hi @Anonymous
Here's a measure to get you previous monday
Last Monday =
VAR _SelectedDate = SELECTEDVALUE('Date'[Date])
VAR _Result = _SelectedDate - 7 - WEEKDAY(_SelectedDate, 3)
RETURN
_Result
Hi, @Anonymous
If your problem has been solved, you could accept the helpful answer as solution.
It will help other community members easily find the solution when they get the similar issue.
If you still need help, please share more details.
Best Regards,
Community Support Team _ Eason
Hi @Anonymous
Here's a measure to get you previous monday
Last Monday =
VAR _SelectedDate = SELECTEDVALUE('Date'[Date])
VAR _Result = _SelectedDate - 7 - WEEKDAY(_SelectedDate, 3)
RETURN
_Result
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 |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
57 | |
49 | |
44 | |
18 | |
18 |