Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Need to add a calulated column that returns a date based on day of week number from a given date.
Example:
Process Date (given date): Friday 09/09/22
Route Departure Day (day of week number): 2
Need calulation to return: Monday 09/12/22
thanks, geo
Solved! Go to Solution.
@Geo_Nelson Sorry, missed a paren:
Departure Date =
VAR __Date = MAX('Table'[Process Date])
VAR __DeptDay = MAX('Table'[Route Departure Day]
VAR __Table = ADDCOLUMNS(CALENDAR(__Date,__Date+7),"WeekdayNum",WEEKDAY([Date]) )
RETURN
MINX(FILTER(__Table,[WeekdayNum] = __DeptDay),[Date])
Hi @Geo_Nelson ,
I think you can try this code to create a calculated column.
Next date = 'Table'[Process Date] + 'Table'[Route Departure Day] + 1
Result is as below.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Geo_Nelson Try:
Departure Date =
VAR __Date = MAX('Table'[Process Date])
VAR __DeptDay = MAX('Table'[Route Departure Day]
VAR __Table = ADDCOLUMNS(CALENDAR(__Date,__Date+7),"WeekdayNum",WEEKDAY([Date])
RETURN
MINX(FILTER(__Table,[WeekdayNum] = __DeptDay),[Date])
@Geo_Nelson Sorry, missed a paren:
Departure Date =
VAR __Date = MAX('Table'[Process Date])
VAR __DeptDay = MAX('Table'[Route Departure Day]
VAR __Table = ADDCOLUMNS(CALENDAR(__Date,__Date+7),"WeekdayNum",WEEKDAY([Date]) )
RETURN
MINX(FILTER(__Table,[WeekdayNum] = __DeptDay),[Date])
User | Count |
---|---|
90 | |
73 | |
68 | |
63 | |
55 |
User | Count |
---|---|
98 | |
89 | |
74 | |
67 | |
62 |