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

TomMartens's avatar
TomMartens
Super User
5 years ago

Hey Anonymous ,

 

I have no idea, how to make the date 2021-01-03 the start of the second week of the year, as I'm just experienced with ISO dates, and ISO weeks.

 

If you get to know how your company calendar is different from the ISO calendar you can create a little algorithm that aligns the week number in Power BI to the week number of your company.

 

I guess you have to talk to your IT department, or to the sales department, as sometimes the calendar is defined by the sales department.

 

Regards,

Tom

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Tom,

Yes I made on excel but I want to make from my original data thats the challenge.

But thanks.

 

Thanks

Amjad