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 have a table like this
I wan't to show total in card for rent. And currently the rent column data type is in text. so I'm unable to create measure for this. Is there any way to create measure for this column.
Solved! Go to Solution.
Hi, @Anonymous
Please try the following methods.
Value = IF([Rent]="NULL",Blank(),[Rent])
Is this the output you expect?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @Anonymous
Please try the following methods.
Value = IF([Rent]="NULL",Blank(),[Rent])
Is this the output you expect?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
You will want to replace the typed "NULL" with actual nulls. Then you can convert the rent field to a decimal and create your measure! You can replace the values in Power Query Editor
Currently I don't have access for data source
@Anonymous , You can change datatype to number .
or try a measure like
sumx(filter(Table, Table[Rent] <> "NULL"), [Rent]*1 )
It getting an error like Cannot convert value 'NULL' of type Text to type Number
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 |
---|---|
110 | |
94 | |
80 | |
67 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |