Forum Discussion
Julian year to Normal Year
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
next to year column in values section there is a drop down button as shown in example below, in that use "don't aggregate"
4 Replies
- parry2k
Super User
I think you year colum is number column and it is adding years, just make sure there is no aggregation on year column
- MadhuReddy
Helper I
- parry2k
Super User
next to year column in values section there is a drop down button as shown in example below, in that use "don't aggregate"