Thx for your answer. Mission more or less accomplished. A follow-up question though.. I am having to show the dates as Day([Date]) which is not very appealing visually.
My solution so far is to add a column with the full date (eg 1 June 2018) converted to string next to the Day([Date]) field and then physically cover the Day([Date]) field in my dashboard. Is there a way to get the date showing as the MDY or MD only without the ugly step of covering up?
1 of 1 people found this helpful
You could create a text field like this to format the date.
Turned out both your solution and my solution did the trick: STR(DATEPART('day',[Date]))+" "+DATENAME('month',[Date selection param])+" "+str(YEAR([Date selection param])).
I was able to drop the real datefield and replace with the strings, maintaining the desired formatting of the table. Big thanks to both you and Anup Kumar Padishala