PowerPivot Splitting Dates Into 3 fields

[cmcreynolds]

Using Excel 2016 64 bit with the built in Data Model and what not.

When building a power pivot table I have come across something a little unusual: when I try to use a date field (say "createdon") as a row in the table, PP splits the date into THREE additional fields: CreatedOnYear, CreatedOnQuarter, and CreatedOnMonth. Not only does it put it in the table, but it creates those fields and puts them back into the data model, as well!

Yes, I forgot to bring in a calendar table, (it's early still, my tea is steeping), BUT - why is splitting a date like this even in PP? Am I missing its usefulness? For me, it's kind of annoying.

 

[Matt Allington]

This is a "feature" in power bi. I want aware it was also in Excel 2016. It is an automatic calendar hierarchy feature. In power bi you can turn it off (right click on the field somewhere from memory)

 

[cmcreynolds]

Yeah, I need to investigate further into how to turn it off in Excel 2016.

In the meantime, once it splits, a simple Ctrl-Z changes it back to just a regular date formatting (like undoing the autocorrect in Word)