Forum Discussion
Solved
Create date columm from odd text format
Hi all, I'm running into an issue trying to create a date from an odd format. From the below table, we have Year, Week Num of Year, and Day of Week Num. I need to turn the first row into Febr...
HI RMDNA
Please give this calculated column a try
Column = VAR BaseDate = DATE(2018,2,1) RETURN BaseDate + ('Table 2'[DayOfWeekNum]-1) + ('Table 2'[WeekNum] * 7) - 7
HI RMDNA
Please give this calculated column a try
Column =
VAR BaseDate = DATE(2018,2,1)
RETURN
BaseDate +
('Table 2'[DayOfWeekNum]-1) +
('Table 2'[WeekNum] * 7) - 7
That seems to have worked. Scaling it out to additional years will be a future issue, but this should do for now. Thanks for the support.
Hi RMDNA
If I understand your data correctly, scaling it out to other years could be as easy as the following tweak
Column = VAR BaseDate = DATE('Table 2'[Year],2,1) RETURN BaseDate + ('Table 2'[DayOfWeekNum]-1) + ('Table 2'[WeekNum] * 7) - 7