query in table

[Anonymous]

Hi Community,

In this table Measure column % of ASP to change in % & show every column to %.

For eg:- % of ASP to change in % W(20) column to change 10.0 to change 10% shown in W-1(O) as it is show in every column.

Please help.

[PowerBIOrg · Accepted solution]

Hi,

If you desired output is as following, you might need to create measure for every column. 

Here is one of the meaure:

_W-2(0) = 
IF(CONTAINSSTRING(SELECTEDVALUE(Table[Measure]),"%"),
    FORMAT(DIVIDE(SELECTEDVALUE(Table[W-2(0)]),100),"0%"),
    FORMAT(SELECTEDVALUE(Table[W-2(0)]),"0.0"))

Regards