Day number of year + year

[TechR21]

Im using the following dax formula to count the day of the year.

DayNoOfYear =
DATEDIFF ( DATE ( YEAR ( 'Table'[Date] ), 1, 1 ), 'Table'[Date], DAY ) + 1

Only problem is I have multiple years and I want to have unique value. 

How can i add a particular year to this? so that I get for example.

date: 2016-01-01

DayNoOfYear: 1-16

date: 2016-01-31

DayNoOfYear: 31-16

date: 2017-01-31

DayNoOfYear: 31-17

[FreemanZ · Accepted solution]

hi @TechR21 

try to add a column like:

DayNoOfYear = 
VAR _days = DATEDIFF ( DATE ( YEAR ( [Date] ), 1, 1 ), [Date], DAY ) + 1
RETURN _days&"-"&FORMAT([Date], "YY")

[TechR21]

perfect, thanks!

[powerbi2srm]

The simplest way is using "Add column from examples" in Power Query. Something like this:

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Is there a reason you're not egetting the day number with the DAY() function?

You could make a calculated column like 

DAY('Calendar'[Date]) & " - " & RIGHT(YEAR('Calendar'[Date]),2)

RIGHT() just takes the last two characters of your year. Hope this helps