Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello
I am unable to sort the date column with the Yearmonth Custom column. getting this below error.
Please Suggest
Thank you
Solved! Go to Solution.
Hi! In order to sort Approved Date, you will need a column that has the same value for monthyear. In your data YearMonthNo has different values for each row. So, for Jan 22 of approved date you would need a column that signifies that this is 1 (for example, you could make a column that has 1/1/2022 for everything that is Jan 22, 2/1/2022 for everything that is Feb 22, etc.).
Proud to be a Super User! | |
Thank you
you need to create a column where the each value in approveddate have one and only value in the order column ,
and 1 value in the order column is to one a only one value of the approved date
ex :
col1 order
jan 22 1
jan 22 1
jan 22 1
feb 22 2
feb22 2
i would suggest you create this column in power query .
hope this helps
If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠
Hi! In order to sort Approved Date, you will need a column that has the same value for monthyear. In your data YearMonthNo has different values for each row. So, for Jan 22 of approved date you would need a column that signifies that this is 1 (for example, you could make a column that has 1/1/2022 for everything that is Jan 22, 2/1/2022 for everything that is Feb 22, etc.).
Proud to be a Super User! | |
User | Count |
---|---|
93 | |
84 | |
78 | |
75 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
60 |