Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 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 ...
Need Help
  • TomMartens's avatar
    TomMartens
    6 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
    6 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
    6 years ago

    Hi Anand,

    eventhough I have timing in my Schedule Departure stop?

  • TomMartens's avatar
    TomMartens
    6 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

Anand24's avatar
Anand24
Icon for Super User rankSuper User
6 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
    6 years ago

    Hi Anand,

    eventhough I have timing in my Schedule Departure stop?

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Thanks Anand.

    It is working.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hey Anand,

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

    Thanks

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

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

       

    • TomMartens's avatar
      TomMartens
      Icon for Super User rankSuper User
      6 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

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Hi Tom,

        Yes I did and got solution thanks. I am stuck with one area. currently, I am making week number from my Schedule Stop Departure,

        (Week = WEEKNUM(Data[Scheduled Stop Departure - Copy],1),but I want to make week canlander as per my orgnization weeks calander which is diffrent than general calander.

        For example, next year 2021 my week 1 will be start 03/Jan/2021. but in excel if you type 03/jan/2021 and use Weeknum function it will show week 2. I want to make calander that match to my orgnization canlander.

        If you could help will be appreciated.

        Thanks