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.
I have a Date column with values in the format March 2023 and i want it to display in the format March FY23 without converting that column to text data type.
Basically i want 2023 to be displayed as FY23 and 2022 to be displayed as FY22 and so on
Solved! Go to Solution.
@Jane689 , in the column tool format, try like MMMM \F\YYY
But you have to do it for month's start date. As date will continue to group like date not month
Month Start Date = eomonth([Date],-1)+1
Hi @Jane689 ,
1. Go to the format tab.
2. Check the data type should be the date.
3. Change the format for FY2022
4. For format for FY22
Best Regards,
Shreya Mukkawar
Appreciate with a Kudos!! (Click the Thumbs Up Button)
Did I answer your question? Mark my post as a solution!
Hi @Jane689 ,
1. Go to the format tab.
2. Check the data type should be the date.
3. Change the format for FY2022
4. For format for FY22
Best Regards,
Shreya Mukkawar
Appreciate with a Kudos!! (Click the Thumbs Up Button)
Did I answer your question? Mark my post as a solution!
@Jane689 , in the column tool format, try like MMMM \F\YYY
But you have to do it for month's start date. As date will continue to group like date not month
Month Start Date = eomonth([Date],-1)+1
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 |
---|---|
49 | |
25 | |
20 | |
15 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
19 | |
18 |