Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I have date formats in the text format like
Jul-20
Aug-20
Sep-20
Oct-20
Nov-20
Dec-20
Jan-21
::::::
feb-21
......So on till Dec-21
I have used custom ordering, used month orders, still I am facing problems.
Could you please help me with this? Pls
Solved! Go to Solution.
@Anonymous , In you date table you have month year
Month Year = FORMAT([Date],"mmm-yyyy")
Create a new column
Month Year sort = FORMAT([Date],"yyyymm")
Mark this as sort column from column tools
How to Create Sort Column and Solve Related Errors: https://youtu.be/KK1zu4MBb-c
@Anonymous , In you date table you have month year
Month Year = FORMAT([Date],"mmm-yyyy")
Create a new column
Month Year sort = FORMAT([Date],"yyyymm")
Mark this as sort column from column tools
How to Create Sort Column and Solve Related Errors: https://youtu.be/KK1zu4MBb-c
Thank you amit!!!. That sorted my problem.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
90 | |
89 | |
79 | |
70 | |
68 |
User | Count |
---|---|
222 | |
128 | |
117 | |
82 | |
77 |