Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.

Reply
Anonymous
Not applicable

Transformed numbers from json cannot add

I have some json data which i transformed into rows. Whren I use these values (they are numbers) I dont hve option to sum them up. How can I figure out what is going on with it?Screenshot 2023-09-19 at 15.36.48.png

1 ACCEPTED SOLUTION
johnt75
Super User
Super User

Click on the ABC123 at the top right of the column and change the type to one of the numeric types.

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

 thanks so much! this was so obvious and yet I spent ages on it!

johnt75
Super User
Super User

Click on the ABC123 at the top right of the column and change the type to one of the numeric types.

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.