Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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.

https://stuconestogacon-my.sharepoint.com/:u:/g/personal/aamjad8961_conestogac_on_ca/EQc50Lt5U0pNgpqOlvYB6WYBhJptuElIrDC2ehOWz5io3Q?e=SZBdFA

 

Thanks

 

 

  

Need Help
  • TomMartens's avatar
    TomMartens
    5 years ago

    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's avatar
    Anand24
    5 years ago

    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:
    customdate.PNG

    Give it a thumbs up if this post helped you in any way and mark this post as a solution if you solved your !!!

  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Anand,

    eventhough I have timing in my Schedule Departure stop?

  • TomMartens's avatar
    TomMartens
    5 years ago

    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

12 Replies

  • TomMartens's avatar
    TomMartens
    Super User
    5 years ago

    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

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi Tom,

       

      I tried to create colmun and I got error in result.

      I am not sure I am doing correct. I am using Schedule Stop Departure column.

      Thanks

       

       

       

       

      • Anand24's avatar
        Anand24
        Super User
        5 years ago

        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's avatar
    Anand24
    Super User
    5 years ago

    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:
    customdate.PNG

    Give it a thumbs up if this post helped you in any way and mark this post as a solution if you solved your !!!

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi Anand,

      eventhough I have timing in my Schedule Departure stop?

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Thanks Anand.

      It is working.

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hey Anand,

      If I need to make"Sep-08-Tue" is there other DAX?

      Thanks

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        I found it how to. I just need to remove Upper and it work.