Forum Discussion

Rajeshcric424's avatar
Rajeshcric424
Frequent Visitor
3 years ago
Solved

Power BI table Desktop

I have table in Power BI having two columns. I need want show 0.31 as 31% which is 0.31 multiply by hundred and add % at last for only for values  stock tank B2 (EUC) and Stock tank C(Res/ARS)  like ...
Data Protection
Need Help
Show and Tell
Tips and Tricks
  • DOLEARY85's avatar
    DOLEARY85
    3 years ago
    Hi,
     
    try this measure:
     
    Value Measure For Multiple Data Formats = IF(OR(CONTAINSSTRING(SELECTEDVALUE('TableName'[Tag_Description]),"(Euc)"),CONTAINSSTRING(SELECTEDVALUE('TableName'[Tag_Description]),"(Res/ARS)")),FORMAT(SUM('TableName'[Value])/100,"Percent"),FORMAT(SUM('TableName'[Value]),"#"))
  • DOLEARY85's avatar
    DOLEARY85
    3 years ago

    Sorry change the last part of the measure ,"#")) to ,"0.00")) for decimal

Rajeshcric424's avatar
Rajeshcric424
Frequent Visitor
3 years ago

This measure is working fine now. Thanks a Lot. How to do as New column without the measure. Is it Possible.

DOLEARY85's avatar
DOLEARY85
Resident Rockstar
3 years ago

I believe due to the different formats you want within a single column it will need to be a measure.