cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Baerbel
Regular Visitor

Mesure don't accept change of a column from text to figures

I'm a beginner and have the problem, that I had to search / replace ":" in a data column (a sign for no data available). Now I was able to convert text into figures. For the report it works.

No I created a measure to be able to use the data basis in Excel as well (Measure_Test = ALL(MyTable[Value]), but the measure shows the [Value]column still as text.

Who can help me (I'm a beginner), thanks in advance

3 ACCEPTED SOLUTIONS
scottsen
Memorable Member
Memorable Member

If you can't convert the column of numbers into a "decimal" or "whole number" data type, it will give you an error about what is "wrong" w/ the data (like the : issues) and you will need to resolve them.

 

Once you CAN convert it to a number, try a measure like:

  Total = SUM(MyTable[Value])

which should return the sum.   Your test measure isn't valid (ALL returns a table, measures need to return single values)

 

View solution in original post

v-haibl-msft
Microsoft
Microsoft

@Baerbel

 

If your values contains “:” in them, you can search and replace using the “Replace Values” function.

Mesure don't accept change of a column from text to figures_1.jpg

 

Once the values have the number format, you can change the data type from Text to number types.

Now you should be able to create a measure using Standard Aggregation Functions.

Mesure don't accept change of a column from text to figures_2.jpg

 

Best Regards,

Herbert

View solution in original post

@v-haibl-msft

 

Thanks a lot - this was what I've done, now I changed the measure to "Sum"

and I found another "beginner" mistake - by connecting Excel to Power BI I've selected in the Power-Pivot-Table the [Value] from the table instead the "Measure" for all my values - now I changed this and it works perfectly.

 

Thanks again Smiley Happy

 

Baerbel

 

 

View solution in original post

4 REPLIES 4
v-haibl-msft
Microsoft
Microsoft

@Baerbel

 

If your values contains “:” in them, you can search and replace using the “Replace Values” function.

Mesure don't accept change of a column from text to figures_1.jpg

 

Once the values have the number format, you can change the data type from Text to number types.

Now you should be able to create a measure using Standard Aggregation Functions.

Mesure don't accept change of a column from text to figures_2.jpg

 

Best Regards,

Herbert

View solution in original post

@v-haibl-msft

 

Thanks a lot - this was what I've done, now I changed the measure to "Sum"

and I found another "beginner" mistake - by connecting Excel to Power BI I've selected in the Power-Pivot-Table the [Value] from the table instead the "Measure" for all my values - now I changed this and it works perfectly.

 

Thanks again Smiley Happy

 

Baerbel

 

 

View solution in original post

scottsen
Memorable Member
Memorable Member

If you can't convert the column of numbers into a "decimal" or "whole number" data type, it will give you an error about what is "wrong" w/ the data (like the : issues) and you will need to resolve them.

 

Once you CAN convert it to a number, try a measure like:

  Total = SUM(MyTable[Value])

which should return the sum.   Your test measure isn't valid (ALL returns a table, measures need to return single values)

 

View solution in original post

@scottsen

 

Thanks a s well, very helpfull

 

 

Best

 

Baerbel

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!