Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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.
User | Count |
---|---|
102 | |
91 | |
87 | |
79 | |
71 |
User | Count |
---|---|
113 | |
105 | |
101 | |
73 | |
65 |