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

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

  • 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