Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Thanks
Solved! Go to 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
Hello @Amjad ,
Create a new custom date column with the following DAX:
Give it a thumbs up if this post helped you in any way and mark this post as a solution if you solved your !!!
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
Hello @Amjad ,
Create a new custom date column with the following DAX:
Give it a thumbs up if this post helped you in any way and mark this post as a solution if you solved your !!!
Hey Anand,
If I need to make"Sep-08-Tue" is there other DAX?
Thanks
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
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
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
Hi Tom,
Yes I made on excel but I want to make from my original data thats the challenge.
But thanks.
Thanks
Amjad
I found it how to. I just need to remove Upper and it work.
Thanks Anand.
It is working.
Hi Anand,
eventhough I have timing in my Schedule Departure stop?
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
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
@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 !!!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
129 | |
106 | |
106 | |
86 | |
72 |