Julian year to Normal Year

[MadhuReddy]

Hi All,

I have Date column and Values are in the format of '2018-07-18 00:00:00.000'. I have created Calender and using below to create Date 

Calendaer = CALENDAR(Date(year(MIN('Table$Value Entry'[Posting Date])),1,1),Date(year(MAX('Table$Value Entry'[Posting Date])),12,31))

and Created Year by using   Year = Year(Calendaer[Date]) ,In Modelling both date and Year are shwoing fine but in report viewer when I try to crate table and add Year ,it shows "241980' instead of 2018 .Can someone help to get get this.

Thanks in advance

[parry2k]

I think you year colum is number column and it is adding years, just make sure there is no aggregation on year column

[MadhuReddy]

@parry2k   As I am new to BI, could you guide me where I can check this please. 

Kind regards

[parry2k · Accepted solution]

next to year column in values section there is a drop down button as shown in example below, in that use "don't aggregate"

[MadhuReddy]

 @parry2k     Thank you , I have used do not summarize  option ticked. 

Thanks again.