Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

DAX Measure

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 mea...
Need Help
Show and Tell
Tips and Tricks
  • v-zhangti's avatar
    v-zhangti
    4 years ago

    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.

v-zhangti's avatar
v-zhangti
Community Support
4 years ago

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.