Forum Discussion
Data view - date display formats
Try the following :
1. select the newly created colum DayDateTime
2. Go to the sort by column
3. Choose the original column DateTime
This should work.
If it works please accept it as a solution and also give KUDOS.
Cheers
CheenuSing
This issue is obiously that I have a number of rows in DayDateTime with the same day date time but I need those to remain as they are, otherwise I could just append a random number to the end of them.
I thought you had a date table.
Try this.
1. Create a calendar(date) table from the transactiondate in fact table.
2. Join the Calendar Table and the Fact Table on the datekeys.
3. Create the new column in the fact table
4. Set the sort by column to TransactionDate in Fact table
this should work
Cheers
CheenuSing
Anonymous are you sayng to create a new table from the column DateTime in my 'Correspondance Register' table? I have not worked out how to do that yet. I select the DateTime column then hit New Table on the icon bar but then I am at a loss as to where to go from there. I guess I will try Googling that. I had tried Google for it in the past but didn't find a good instruction.
Creating a Calendar / Date table is as simple as writing
Calendar = CALENDAR (MINX('YourFactTable', [YourFactTableDate]),MAXX('YourFactTable', [YourFactTableDate]))
This will create the table Calendar in your data model with Date as a column.
Cheers
CheenuSing
What I want in my table - in order to display in a report is a date pre-appended with the three letter day abbriviation.
This issue is obiously that I have a number of rows in DayDateTime with the same day date time but I need those to remain as they are, otherwise I could just append a random number to the end of them.
In this scenario, I would suggest you to create a Day column to show the three letter day abbreviation only, then show Day column and DateTime column together in the report. See my sample below.
MyTestTable
The data is sorted correctly in the report.
Regards
Thanks v-ljerr-msft yes that works and I had thought of it but I am still hoping there may be a more integrated way of acheiving this rather than having an entirely separate field, after all the day is part of the date and it would be disappointing if MS have not provided a means to configure the display of it outside of their supplied formats.
