Analyse in Excel and Date Format

[Claude_]

Using "Analyse in Excel"  I do understand that we have to define measure to be able to sum values.

I didn't find any guidance on how to handle date.  Once in Excel, date member are like ordinary member and I cannot apply timeslicer on it.    Is that a limitation?   Is there an alternative?

Note:  In the power bi Desktop and Services, I use a date table linked to data.

Regards

Claude

[v-yuezhe-msft · Accepted solution]

Hi @Claude_,

I can reproduce you issue. Based on my observation, the issue is caused by that Power Pivot treats Date columns as text. I find a connect item and several threads stating the issue that PowerPivot treats date columns as text, I would recommend you vote the connect item and check the following similar threads.

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/c0253620-6ae0-46ea-8b6e-124e6c950239/powerp...

http://stackoverflow.com/questions/27913051/powerpivot-incorrectly-convert-date-value-to-text-in-piv...

Thanks,

Lydia Zhang

[Anonymous]

Is there any way to force columns to date format ?

I have many dates formatted as date in powerbi that powerpivot with analyse in excel reads as text and I want to filter them using power pivot date filters.

[Anonymous]

I have created a idea for this. Vote!

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/40346272-analyze-in-excel-date-co...