Forum Discussion

MadhuReddy's avatar
MadhuReddy
Icon for Helper I rankHelper I
8 years ago
Solved

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

 

  • parry2k's avatar
    parry2k
    8 years ago

    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

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

    • MadhuReddy's avatar
      MadhuReddy
      Icon for Helper I rankHelper I

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

      Kind regards

       

      • parry2k's avatar
        parry2k
        Icon for Super User rankSuper 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"