Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Using var and format

Hi Community,    I'm trying to create measures using variables in Power BI, but in the final result I'm not able to save the result as a numerical value which is not allowing me to aggregate the va...
Need Help
  • d_gosbell's avatar
    d_gosbell
    6 years ago

    Remove the call to FORMAT() as that is what is converting the result to a string. Instead set the formatting of the measure using the Formatting section of the Modeling tab in the ribbon

Anonymous's avatar
Anonymous
Not applicable
6 years ago
 

RETURN
SWITCH(TRUE(),
MAX('P&L MAPPING'[ACC DESCRIPTION])="TOTALVOLLY",FORMAT(TOTALVOL_LY,"###0.##0"),
MAX('P&L MAPPING'[ACC DESCRIPTION])="TOTALGTOLY",FORMAT(TOTALGTO_LY/1000,"###0.##0")


RETURN
SWITCH(TRUE(),
MAX('P&L MAPPING'[ACC DESCRIPTION])="TOTALVOLLY",VALUE(FORMAT(TOTALVOL_LY,"###0.##0")),
MAX('P&L MAPPING'[ACC DESCRIPTION])="TOTALGTOLY",VALUE(FORMAT(TOTALGTO_LY/1000,"###0.##0"))

 

d_gosbell's avatar
d_gosbell
Super User
6 years ago

Remove the call to FORMAT() as that is what is converting the result to a string. Instead set the formatting of the measure using the Formatting section of the Modeling tab in the ribbon