Tips : Change Periode(yymm) to datetime

[ymulyana]

I have problem when using period time like this : 201301,201302 etc. But when i using formula in powerpivot such as : Sales Previous Month, Sales Month last Year, YTD, MAT. And then after i tried conversion from yymm (201301) to date time (01/01/2013) its works.


See the file for the details,
url : http://vivezashop.com/images/DimDate.xlsx




Regards

 

[BrianMH]

Sorry it's not very clear what you are asking. As you said if you convert it it works so it sounds like you have a solution.

 

[ymulyana]

Sorry it's not very clear what you are asking. As you said if you convert it it works so it sounds like you have a solution.

yes i have a solution with this case, may be it can works if there's some proble like this. Or there's any alternative way.

Regarsds

 

[scottsen]

Thanks ymulyana. To summarize the tip for others without opening the workbook... the suggest is:

"If you have a date column in yyyyMM format, create a new calculated column with this formula to create a real date"
=DATE(LEFT(A6,4),RIGHT(A6,2),1)

 

[ymulyana]

Thanks ymulyana. To summarize the tip for others without opening the workbook... the suggest is:

"If you have a date column in yyyyMM format, create a new calculated column with this formula to create a real date"
=DATE(LEFT(A6,4),RIGHT(A6,2),1)

Yeay great, thanks in advanced.

Regarsd