Forum Discussion
Custom Date
Hi All,
I want to make my custome date where I need to show only as per example formate. "SEP-08-MON".
I tried with hirarchies but still not getting the required result.
If any one know please share.
Here is the file link current date view.
Thanks
12 Replies
- TomMartens
Super User
Hey Anonymous ,
you can use DAX to create column in your Calendar table like this:
Custom Date = FORMAT('Calendar'[Date] , "MMM-DD-DDD")The result will look like this, here a table visual:
Just use the column Custom Date on the axis.
Please be aware that data of multiple years might be aggregated.
Hopefully, this provides what you are looking for.
Regards,
Tom
- Anand24
Anonymous,
Try this considering name of table is "Data":
Custom Date = FORMAT(Data[Scheduled Stop Departure],"MMM-DD-DDD"))
Give a thumbs up if this post helped you in any way and mark this post as solution if it solved your query !!!
- Anand24
Hello @Amjad ,
Create a new custom date column with the following DAX:
Custom Closes: UPPER(FORMAT(NombreDeColumna[NombreDeColumn],"MMM-DD-DDD"))Refer to the following image:Give it a thumbs up if this post helped you in any way and mark this post as a solution if you solved your !!!
