Custom Date

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

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 !!!

Hi Anand,

eventhough I have timing in my Schedule Departure stop?

Hello @Amjad ,

just use the formula of my post, it is exactly the same formula published by @Anand24, only without the UPPER. Looks like I assumed you didn't need all the uppercase and lowercase characters.

Best regards

Tom