My Online Training Hub

Learn Dashboards, Excel, Power BI, Power Query, Power Pivot

How to tell excel that an entry is a specific month?|Dashboards & Charts|Excel Forum|My Online Training Hub

You are here: Home / How to tell excel that an entry is a specific month?|Dashboards & Charts|Excel Forum|My Online Training Hub

vba course banner

Avatar
sp_LogInOut Log In sp_Registration Register
sp_Search Search
Advanced Search
Search
Forum Scope



Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
sp_Search Search
sp_RankInfo
Lost password?
sp_PrintTopic sp_TopicIcon
How to tell excel that an entry is a specific month?
Avatar
Alex Meins

Active Member
Members
Level 0
Forum Posts: 5
Member Since:
May 25, 2021
sp_UserOfflineSmall Offline
1
February 28, 2022 - 7:46 pm
sp_Permalink sp_Print

Hello,

i just created a smart table and used colums, one for month and one for year.

Problem is, that now the pivot table is not recognizing the month entries as "dates" as they are words and excel doesn't know which date that is.

What can i do, to keep the convenient level data input for my key users as they dont want to type in a specific date but just the month and the year per line, but also use timeline slicers for my dashboard.

Would it work with a helper column?

 

Thank you very much,

LxMeCapture-1.PNGImage Enlarger

sp_PlupAttachments Attachments
sp_AnswersTopicSeeAnswer See Answer
Avatar
Velouria
London or thereabouts
Moderator
Members


Trusted Members

Moderators
Level 4
Forum Posts: 648
Member Since:
November 1, 2018
sp_UserOfflineSmall Offline
2
March 1, 2022 - 12:41 am
sp_Permalink sp_Print

Yes, you could add a helper column using DATEVALUE and creating a date string that your regional settings can work with - for example (zB):

 

=DATEVALUE("1 "&[@Monat]&" "&[@Jahr])

sp_AnswersTopicAnswer
Answers Post
Avatar
Alex Meins

Active Member
Members
Level 0
Forum Posts: 5
Member Since:
May 25, 2021
sp_UserOfflineSmall Offline
3
March 1, 2022 - 1:28 am
sp_Permalink sp_Print

Thank you so much! Exactly what i needed!

 

THX

Alex

sp_Feed
Go to top
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Catalin Bombea, John Kobiela, Malcolm Sawyer
Guest(s) 10
Currently Browsing this Page:
1 Guest(s)
Top Posters:
SunnyKow: 1432
Anders Sehlstedt: 873
Purfleet: 414
Frans Visser: 346
David_Ng: 306
lea cohen: 222
Jessica Stewart: 216
A.Maurizio: 202
Aye Mu: 201
jaryszek: 183
Newest Members:
Melanie Ford
Isaac Felbah
Adele Glover
Hitesh Asrani
Rohan Abraham
Anthony van Riessen
Erlinda Eloriaga
Abisola Ogundele
MARTYN STERRY
Rahim Lakhani
Forum Stats:
Groups: 3
Forums: 24
Topics: 6356
Posts: 27793

 

Member Stats:
Guest Posters: 49
Members: 32324
Moderators: 3
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: MOTH Support, Velouria, Riny van Eekelen