DATEDIFF adding day of year number power bi

[dicken]

Hi,

I'm trying to add the day of the year number in a power bi calendar , and keep seeing the following;

DATEDIFF (STARTOFYEAR ('Date' [Date]),'Date' [Date],DAY)+1

I have tried using this and just get errors,

"Day of Month", DAY([Date]) , 
"Day of Week", WEEKDAY([Date] ,2)  ,
"a"  ,  DATEDIFF(STARTOFYEAR(Table1[Order Date]),Tablle1[Order Date] ,DAY )

When I move onto the second Date after closing STARTOFYEAR , as soon as I start typing Table1, the intelesence only offer calculate or calculatetbale functions,
What am I doing wrong?

Richard.

 

[dicken]

Hi,

I'm trying to add the day of the year number in a power bi calendar , and keep seeing the following;

DATEDIFF (STARTOFYEAR ('Date' [Date]),'Date' [Date],DAY)+1

I have tried using this and just get errors,

"Day of Month", DAY([Date]) ,
"Day of Week", WEEKDAY([Date] ,2)  ,
"a"  ,  DATEDIFF(STARTOFYEAR(Table1[Order Date]),Tablle1[Order Date] ,DAY )

When I move onto the second Date after closing STARTOFYEAR , as soon as I start typing Table1, the intelesence only offer calculate or calculatetbale functions,
What am I doing wrong?

Richard.

Udate

 

[smozgur]

Please do not mark a post as the solution that doesn't contain an answer.

 

[dicken]

Please do not mark a post as the solution that doesn't contain an answer.

Then how do I update or edit the question?