Forum Discussion

AllanBerces's avatar
AllanBerces
Post Prodigy
2 years ago
Solved

Divide Function

Hi,

Can anyone pls help how can i write it on Power BI the formula.

Thank you

Allan

  • Thank you on your reply. Currently I have.

     

    Thank you

    Allan

4 Replies

  • PijushRoy's avatar
    PijushRoy
    Community Champion

    Hi AllanBerces 

    Please use 
    Measure = DIVIDE(Column1,Column2,-)
    Eaxmple - https://learn.microsoft.com/en-us/dax/divide-function-dax

     

    Please create a pbix that contains sample data but still reflects your semantic model (tables, relationships, calculated columns, and measures). Upload the pbix to OneDrive, Google Drive, or dropbox and share the link in this thread. If you are using a spreadsheet to create/import the sample data instead of the manual import method, share the spreadsheet as well. 


    Let me know if that works for you


    If your requirement is solved, please make THIS ANSWER a SOLUTION ✔️ and help other users find the solution quickly. Please hit the LIKE 👍 button if this comment helps you.

    Thanks
    Pijush
    Linkedin

    • AllanBerces's avatar
      AllanBerces
      Post Prodigy

      Thank you on your reply. Currently I have.

       

      Thank you

      Allan

  • Hi anyone can pls help me how to acheived the output on my table.

     

  • PijushRoy's avatar
    PijushRoy
    Community Champion

    Hi AllanBerces 

    Please create a calculated column

    Please update column name and table name

     

    Column = DIVIDE('Table (3)'[Daily_Plan_Cum],'Table (3)'[Daily_Plan_Rev])

     

     


    Let me know if that works for you


    If your requirement is solved, please make THIS ANSWER a SOLUTION ✔️ and help other users find the solution quickly. Please hit the LIKE 👍 button if this comment helps you.

    Thanks
    Pijush
    Linkedin