Notifications
Clear all
Dashboards & Charts
3
Posts
2
Users
0
Reactions
51
Views
Topic starter
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,
LxMe
Posted : 01/03/2022 5:46 am
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])
Posted : 01/03/2022 10:41 am
Topic starter
Thank you so much! Exactly what i needed!
THX
Alex
Posted : 01/03/2022 11:28 am
