Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I have a report see below, where in one of the columns "D" I am unable to change Data Type to Whole Number, alonng with Format to Whole Number and Summarization to Sum.
The one difference I noticed is the numbers are displayed on the left hand side of the column unl;ike the rest whicj are to the right.
Any ideas?
Solved! Go to Solution.
Hi @trevorG1
It's still formated as Text or as Any.
Go back to Query Editor and convert to Number there and load back in
Thanks
Joe
If this post helps, then please consider Accept it as the solution
ct that worked, thanks Joe
Hello @trevorG1 ,
yes as @JoeBarry mentioned, and also check if all the records in the column are numbers.
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Follow me on Linkedin
Vote For my Idea💡
Proud to be a Super User! | |
Hi @trevorG1
It's still formated as Text or as Any.
Go back to Query Editor and convert to Number there and load back in
Thanks
Joe
If this post helps, then please consider Accept it as the solution
User | Count |
---|---|
93 | |
84 | |
78 | |
75 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
60 |