Forum Discussion
Data view - date display formats
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.
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.
Sorry for the late reply.
I just added one more column called DateKey in the FactTable which is defined as
DateKey = (Year('FactTable'[DateTime])*10000+Month('FactTable'[DateTime])*100+day('FactTable'[DateTime]) )
Then set the DayDateTime to be sorted by this and I had no issues.
Check it out it should work.
CheenuSing