Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
phillgrey
New Member

couldn't load the data for this visual error , caculation error in measure

‎08-03-2022 03:30 PM
Can anyone help, I keep getting the following error when trying to create a column with line series model. I have create two calculations using a SUM, converted the data type to an INT in SQL and also to a whole number in BI, still wont work. Any ideas? Thanks
error help.png
Labels:
Message 1 of 3
192 Views
0
1 ACCEPTED SOLUTION
ray_ux
Memorable Member
Memorable Member

‎08-03-2022 03:32 PM

@phillgrey 

You can try using the "VALUE() function" in the column, but you should certainly be able to change it within power query

View solution in original post

Message 2 of 3
190 Views
2 REPLIES 2
ray_ux
Memorable Member
Memorable Member

‎08-03-2022 03:32 PM

@phillgrey 

You can try using the "VALUE() function" in the column, but you should certainly be able to change it within power query

Message 2 of 3
191 Views
phillgrey
New Member
In response to ray_ux

‎08-03-2022 03:33 PM

Thanks, Im trying to do it SQL side to help with performance but the power query work . Cheers!

Message 3 of 3
187 Views
0

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel1

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

View All