Forum Discussion
Custom column gives a data type error when switching from mixed to full import mode
cmiller1221 , I doubt your datatype of the fixed decimal number.
For sum of duration refer to these
https://radacad.com/calculate-duration-in-days-hours-minutes-and-seconds-dynamically-in-power-bi-using-dax
https://social.technet.microsoft.com/wiki/contents/articles/33644.powerbi-aggregating-durationtime-in-dax.aspx
https://www.pbiusergroup.com/communities/community-home/digestviewer/viewthread?GroupId=547&MessageKey=814a2cb4-3cca-4cd1-a620-c467adeaaaf6&CommunityKey=b35c8468-2fd8-4e1a-8429-322c39fe7110&tab=digestviewer
https://community.powerbi.com/t5/Quick-Measures-Gallery/Chelsie-Eiden-s-Duration/m-p/793639#M389
Super UserCan you verify that the data types as seen in Power Query or Import Mode are EXACTLY the same as they were when it was in Direct Query mode? Don't just assume by looking at the data in the Desktop, you need to note the data type(s) in Power Query.
Does the issue go away if you revert back to Direct Query?