Forum Discussion
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
- PijushRoyCommunity Champion
Hi AllanBerces
Please use
Measure = DIVIDE(Column1,Column2,-)
Eaxmple - https://learn.microsoft.com/en-us/dax/divide-function-daxPlease 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- AllanBercesPost Prodigy
Thank you on your reply. Currently I have.
Thank you
Allan
- AllanBercesPost Prodigy
Hi anyone can pls help me how to acheived the output on my table.
- PijushRoyCommunity Champion
Hi AllanBerces
Please create a calculated columnPlease 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