Now Reading: Using Divide in a DAX Measures in Microsoft Power BI
1
-
01
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
Support The Site
