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
