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 everyone,
I created a filter with a week number that works fine. "Weekday number", WEEKNUM( [Date] ),
However, I need to inform the range of the week, for example:
Today is 15/11/2020
I would like to show in the filter
W46 - 09/11 to 15/11
For the next weeks
W47 - 16/11 to 22/11.
W48 - 23/11 to 29/11
How can I do that? I tried to find something similar like this on the community but I couldn`t.
Can you please help me?
Thanks.
Solved! Go to Solution.
Hi, @fabiolamelo , you might want to try this pattern,
Week Selected =
VAR __day_selected =
MAXX ( ALLSELECTED ( 'Calendar'[Date] ), 'Calendar'[Date] )
VAR __start_of_week =
__day_selected - WEEKDAY ( __day_selected, 2 ) + 1
VAR __week_selected =
DATESINPERIOD ( 'Calendar'[Date], __start_of_week, 7, DAY )
RETURN
MINX ( __week_selected, 'Calendar'[Date] ) & " to " & MAXX ( __week_selected, 'Calendar'[Date] )
///////////////////////////
Next Week = CALCULATE( [Week Selected], DATEADD('Calendar'[Date], 7, DAY) )
//////////////////////////
Next 2 Week = CALCULATE( [Week Selected], DATEADD('Calendar'[Date], 14, DAY) )
Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension! |
DAX is simple, but NOT EASY! |
Hi, @fabiolamelo , you might want to try this pattern,
Week Selected =
VAR __day_selected =
MAXX ( ALLSELECTED ( 'Calendar'[Date] ), 'Calendar'[Date] )
VAR __start_of_week =
__day_selected - WEEKDAY ( __day_selected, 2 ) + 1
VAR __week_selected =
DATESINPERIOD ( 'Calendar'[Date], __start_of_week, 7, DAY )
RETURN
MINX ( __week_selected, 'Calendar'[Date] ) & " to " & MAXX ( __week_selected, 'Calendar'[Date] )
///////////////////////////
Next Week = CALCULATE( [Week Selected], DATEADD('Calendar'[Date], 7, DAY) )
//////////////////////////
Next 2 Week = CALCULATE( [Week Selected], DATEADD('Calendar'[Date], 14, DAY) )
Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension! |
DAX is simple, but NOT EASY! |
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 |
---|---|
114 | |
98 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |