How to add custom Year column in data

[vikas_nandanwar]

Hi,

I have transaction date as one of the column

I get auto calendar in my measure field.

I have another sheet with same date but the year should be displayed as Planned year

Like

Sales Transaction date =

2016

2017

Plan Transaction year =

2017

I want Plan Transaction year = 2017P

How to get that?

Thanks,

Vikas

[Anil_Babu_Samineni]

Not really sure?

[Plan Transaction Year] & 'P' as [Plan Transaction Year]

OR

Load [Sales Transaction Year], 'Sales' as Flag From Sales;

Load [Plan Transaction Year] & 'P as [Plan Transaction Year], 'Plans' as Flag From Sales;

[pipuindia99]

Hi,

Like this

Sales Transaction date = 2016, 2017

max([Sales Transaction date])&'P' as [Plan Transaction Year]

Plan Transaction year = 2017