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
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Top Kudoed Authors