Custom Date

[Anonymous]

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

Thanks

[TomMartens · Accepted solution]

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 · Accepted solution]

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

[Anonymous · Accepted solution]

Hi Anand,

eventhough I have timing in my Schedule Departure stop?

[Anand24 · Accepted solution]

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

[Anonymous]

Hey Anand,

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

Thanks

[TomMartens · Accepted solution]

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]

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]

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]

Hi Tom,

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

But thanks.

Thanks

Amjad

[Anonymous]

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

[Anonymous]

Thanks Anand.

It is working.

[Anonymous · Accepted solution]

Hi Anand,

eventhough I have timing in my Schedule Departure stop?

[TomMartens · Accepted solution]

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]

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]

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