Hey guys
This weird and never happend to me, in power pivot/query. I' "cleaning" and preparing a file so i can do a pivot table.
One of the fields of my file is a date field, or it is supposed to be. Formating as a number it shows me the right number for that day. I even made another column adding 1 and subtracting one. It really shows me the date.
When i'm doing a pivot table, on that field, it shows me the month name and i can't do nothing about any format...
Did it happen to anyone of you or is not that weird for you guys?
Can you help me please?
Best regards
Pedro
Bookmarks