Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

query in table

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 i...
Need Help
  • PowerBIOrg's avatar
    PowerBIOrg
    3 years ago

    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

     

PowerBIOrg's avatar
PowerBIOrg
Resolver II
3 years ago

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