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.
Hello, I'm trying to create an index column, where when the data is grouped by week, and the pickup date is in ascending order, the index reads 1, 2, 3, 4, etc. and that starts back over at 1 for the next week.
How would I go about doing that?
@hnblann This solves everything except how to resolve ties between duplicate dates. PBIX is attached below signature.
Column =
VAR __Date = [Date]
VAR __Week = [Week]
VAR __WeekTable = FILTER(ALL('Table2'),[Week] = __Week)
VAR __TextTable = CONCATENATEX(__WeekTable,[Date] * 1.,"|",[Date])
VAR __Table =
ADDCOLUMNS(
GENERATESERIES(1,COUNTROWS(__WeekTable),1),
"__Date", PATHITEM(__TextTable,[Value])
)
RETURN
MAXX(FILTER(__Table, [__Date] = (__Date * 1.) & ""),[Value])
User | Count |
---|---|
80 | |
74 | |
62 | |
61 | |
45 |
User | Count |
---|---|
108 | |
97 | |
88 | |
81 | |
61 |