Forum Discussion

volkanbygl's avatar
volkanbygl
Regular Visitor
8 years ago
Solved

Divide two columns DAX

Hello,   I need to calculate percentage and this is the DAX formula which isnt working:   PercentDifference= DIVIDE('Query1'[SALES]*100; 'Query1'[PLANNED_SALES] )   Divide function works if I p...
Need Help
  • volkanbygl's avatar
    volkanbygl
    8 years ago

    Hello all, 

     

    Thank you for you efforts. I finally found the solution. 

     

    What I needed to do was:

    - create three measures:

        Sale = SUM(Query1[SALES])*100

        PlannedSale = SUM(Query1[PLANNED_SALES])

        Percentage= DIVIDE([Sale];[PlannedSale])

     

    Only this way worked for me and it is cool. Thank you guys 

ozandikerler's avatar
ozandikerler
Frequent Visitor
7 years ago

Power BI gives error when I add a new column and type = IFERROR( ([Hedeflenen]-[Gerceklesen])/[Hedeflenen],0)

 

"Expression.Error: The name 'IFERROR' wasn't recognized.  Make sure it's spelled correctly."

newpi's avatar
newpi
Helper V
6 years ago

Hi,

 

I'm trying to do a simple division of two numerci field columns but when I write the DAX measure. The columns don't load by itself. Its showing me colored text but there is no dropdown appearing as I type the column name. Both the numeric fields are part of the same table.