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.
In my data table there is a column which contains dates of every weekend (every Friday, eg: 26 Aug 2022, 02 Sep 2022), another column containing only day number (eg: 22,23,24 ; 29,30,1,2). How do I convert this day column which is in text format into DDMMYYYY date format.
Requesting the experts to kindly help me out from this situation.
Solved! Go to Solution.
Ok, I see what you mean. Try this (I'm assuming that the week date is the end of the week):
New date =
VAR _DayInt =
VALUE ( 'Table'[Day] )
VAR _DayDate =
DATE ( YEAR ( 'Table'[Week] ), MONTH ( 'Table'[Week] ), _DayInt )
RETURN
IF (
_DayDate > 'Table'[Week],
DATE ( YEAR ( 'Table'[Week] ), MONTH ( 'Table'[Week] ) - 1, _DayInt ),
_DayDate
)
Please confirm that the highlighted rows are the expected result.
Proud to be a Super User!
Paul on Linkedin.
Thank you soo much for your time and effort. Appreciate your skill
Ok, I see what you mean. Try this (I'm assuming that the week date is the end of the week):
New date =
VAR _DayInt =
VALUE ( 'Table'[Day] )
VAR _DayDate =
DATE ( YEAR ( 'Table'[Week] ), MONTH ( 'Table'[Week] ), _DayInt )
RETURN
IF (
_DayDate > 'Table'[Week],
DATE ( YEAR ( 'Table'[Week] ), MONTH ( 'Table'[Week] ) - 1, _DayInt ),
_DayDate
)
Please confirm that the highlighted rows are the expected result.
Proud to be a Super User!
Paul on Linkedin.
If you wish to assign the same month and year as the Week field, try:
New date =
DATE ( YEAR ( Table[Week] ), MONTH ( Table[Week] ), VALUE ( Table[Day] ) )
Proud to be a Super User!
Paul on Linkedin.
Well, this doesn't solve my issue as the day numbers against the last week of August (eg: 29,30,...) are being shown as last week of September (29-09-2022) instead of that of August(29-08-2022). Is there any other way?
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
91 | |
89 | |
79 | |
69 | |
68 |
User | Count |
---|---|
222 | |
128 | |
117 | |
82 | |
77 |