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.
eed to convert a number which is a text format from SAP Hana to number based on Direct Query report.
I tried to add now column like this
Size = VALUE ('Data'[size]. Example: Instead of showing 100 as text it shows i think Pbi sums of all 100 it founds.
I
Hi,
it doesnt work as it is part of a direct query. Need to create a new column
@Sergi , Try to change that in column tools.
Click on column, You should see an option for column tools on tabs. Click on that and change data type to whole number and try
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 |
---|---|
105 | |
94 | |
75 | |
63 | |
62 |
User | Count |
---|---|
137 | |
105 | |
104 | |
80 | |
63 |