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.
Dear all,
I have a table like below:
I want to sort the above table by "Date of Birth" (without considering the year).
i.e. after sorting, my output should look like below.
How can I do this? Please help.
Thank You!
Solved! Go to Solution.
Create a custom column and use the formula
Birthday = FORMAT([Date of Birth], "MM-DD")
Now sort on the Birthday column
Create a custom column and use the formula
Birthday = FORMAT([Date of Birth], "MM-DD")
Now sort on the Birthday column
Thank you both of you!
So it looks like you are sorting by month number in year is that correct?
To achieve this you will need a column to faciliate the sort.
in this case create a column
Month Num = MONTH(Table1[Date of Birth])
then select the "date of birth" column and use the "Sort By Column" button to select "Month Num" this will sort the months in the correct order as per your screen shot.
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 |
---|---|
111 | |
94 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |