Using Divide in a DAX Measures in Microsoft Power BI
In this Video, I’ll create a DAX (Data Analysis eXpression) function (Divide) to alter a Measure. DAX can be used in Microsoft Power BI, Microsoft PowerPivot, and MDX. It’s a relatively easy way to model your data.
Today’s DAX Expression:
Gross Margin % := DIVIDE(SUM(‘Sales Line Items'[Gross Margin]), SUM(‘Sales Line Items'[Total Sales]), 0)
Using Divide in a DAX Measures in Microsoft Power BI
Blog Syndicated with Belinda Allen’s Permission
More About This Author
Array
- Dyn365GP27 March 2023Add a prefix to a field in Microsoft Power BI via Power Query
- Dyn365GP24 March 2023Microsoft Power BI Story Telling with PowerPoint
- Dyn365GP22 March 2023Parameters for Excel File Path in Microsoft Power BI
- Dyn365GP20 January 2022Microsoft Dynamics Business Central as a Data Type in Excel via Power BI