Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I am trying to achieve the above. Have a date range for instance 3/12/2023 - 3/18/2023 and when i expand the + sign on a matrix visual I would love to see the dates in between 3/13/2023, 3/14/2023,3/15/2023, 3/16/2023,3/17/2023,3/18/2023.
HI @lamlamm24,
You can try to create a calculated column with following formulas to show the current week ranges that include year start/end checkings:
Weekbreakdown =
VAR sWeek =
[Date] - WEEKDAY ( [Date], 1 ) + 1
RETURN
IF (
WEEKNUM ( [Date], 1 ) <> 1
&& WEEKNUM ( [Date], 1 ) <> WEEKNUM ( DATE ( YEAR ( [Date] ), 12, 31 ), 1 ),
sWeek & "-" & sWeek + 6,
IF (
WEEKNUM ( [Date], 1 ) = 1,
DATE ( YEAR ( [Date] ), 1, 1 ) & "-" & sWeek + 6,
sWeek & "-"
& DATE ( YEAR ( [Date] ), 12, 31 )
)
)
Regards,
Xiaoxin Sheng
This is the DAX i used for week break down but its Blank.
I also tried this DAX
If you have a date calendar, then you can just drag both fields over to a table and it should show the dates between. Depending on the type of visual you are using (e.g. matrix), there may be an option to show the +/- buttons under formatting.
This is exactly what i want to see. But what DAX did you use for the WeekDateRange.
User | Count |
---|---|
77 | |
77 | |
68 | |
67 | |
49 |
User | Count |
---|---|
108 | |
105 | |
93 | |
83 | |
64 |