Determining date of the day number of a year

This recipe comes in handy if you know the day number of a year and wish to determine the actual date of that day.

Getting ready

To prepare for this recipe, perform the following steps:

1. Create a table using the following formula:

R05_Calendar = CALENDAR(DATE(2018,1,1),DATE(2022,12,31))

2. In this table, create the following column:

DayNoOfYear = ('R05_Calendar'[Date] - DATE(YEAR('R05_Calendar'[Date]), 1, 1 )) * 1 + 1

How to do it...

To implement this recipe, perform the following steps:

1. Create a column...