1
Vote

Check formatting for Percentage

description

A column of Decimal Number type in PowerPivot and Format=Percentage is displayed as Currency when I evaluate the table in DAX Studio. It should be displayed as a Percentage in Excel, too

file attachments

comments

mssqlgirl wrote Oct 23, 2012 at 1:41 AM

Similar issue seesm to occur for Tabular Model. A calculated measure from AdventureWorks, "Internet Total Sales" has currency formatting. It seems that the output is displayed as plain numbers on both Excel table and DAX Output grid.

EVALUATE
SUMMARIZE(
    'Internet Sales'
    , "Internet Total Sales"
    , 'Internet Sales'[Internet Total Sales]
)