Forum Discussion
Need Help with Custom Sorts
Thank you all for your feedback. Another issue occurs while using the Related fir custom sorting .
I am using the RELATED DAX query and it works in some instances . Related tables 'Sheet1' and RTOTable. However, after the Related query is executed in the Sheet1 table, some values are blank even though there is an associated value. All RTO_ID are listed except for "8" and "10". Why is this happening? See both tables below
Sheet1 Table after the RELATED query is executed
RTOTable
Anonymous Duration
You will need to convert those to seconds, add them and essentially convert them back more or less. Look at the links below, they should get you what you need.
https://community.powerbi.com/t5/Quick-Measures-Gallery/Chelsie-Eiden-s-Duration/m-p/793639#M389
https://community.powerbi.com/t5/Community-Blog/Aggregating-Duration-Time/ba-p/22486
https://community.powerbi.com/t5/Quick-Measures-Gallery/Duration-to-Seconds-Converter/m-p/342279#M92
Thank you all for your feedback. Another issue occurs while using the Related fir custom sorting .
I am using the RELATED DAX query and it works in some instances . Related tables 'Sheet1' and RTOTable. However, after the Related query is executed in the Sheet1 table, some values are blank even though there is an associated value. All RTO_ID are listed except for "8" and "10". Why is this happening? See both tables below
Sheet1 Table after the RELATED query is executed
RTOTable
Hi Anonymous ,
Please check whether the field format is the same as the RTO table.
For example, I have found that one of the type fields in RTO table 'Weeks 3+' while in Sheet1 Table is 'Week 3+' so that it would return blank in the Sheet1 Table.
Simliar issue with '72 Hours - 1 Week', check whether the spaces are the same etc.
Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.Thank you so mujch v-yingjl! I needed your 2nd pair of eyes 🙂
