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
to find the last Monday try this:
Measure =
VAR _D =
SELECTEDVALUE ( table[date] ) -- this will return the selected date
VAR _WN =
WEEKDAY ( _D, 2 ) -- this will returns a number from 1 to 7 identifying the day of the week of a date
VAR _WDV = _WN - 1 -- find the variance between Monday and selected date in a week
VAR _MD = _D - _WDV -- find the Moday date in the selected date week
RETURN
_MD - 7
-- last week Monday date
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/
HI @Anonymous
to find the last Monday try this:
Measure =
VAR _D =
SELECTEDVALUE ( table[date] ) -- this will return the selected date
VAR _WN =
WEEKDAY ( _D, 2 ) -- this will returns a number from 1 to 7 identifying the day of the week of a date
VAR _WDV = _WN - 1 -- find the variance between Monday and selected date in a week
VAR _MD = _D - _WDV -- find the Moday date in the selected date week
RETURN
_MD - 7
-- last week Monday date
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/
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 |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
129 | |
106 | |
106 | |
86 | |
72 |