Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
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)
If your values contains “:” in them, you can search and replace using the “Replace Values” function.
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.
Best Regards,
Herbert
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
Baerbel
If your values contains “:” in them, you can search and replace using the “Replace Values” function.
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.
Best Regards,
Herbert
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
Baerbel
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)
@Anonymous
Thanks a s well, very helpfull
Best
Baerbel
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
98 | |
78 | |
65 | |
60 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |