Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
If I want to write a dax measure for Total sales, what would it be?
1. Is it the summation of net sales? or
2. should I subtract Distribution and warehousing cost from Net sales?
Solved! Go to Solution.
@Alex_Hasan , They are negative, you can add up
Total Sales = Sum(Table[Net Sales]) +Sum(Table[Distribution Cost]) +Sum(Table[warehousing Cost])
@Alex_Hasan, Not very clear
If net sales is column
A measure
Total Sales = Sum(Table[Net Sales])
should I subtract Distribution and warehousing cost from Net sales?
What is the requirement ?
Total Sales = Sum(Table[Net Sales]) -Sum(Table[Distribution Cost]) -Sum(Table[warehousing Cost])
Oh sorry, there was a mistake in the question. Now I am going to say it clearly.
When we want to calculate total sales, we add up all the cost related to the sales and subtract discount from it.
In the Net Sales column, the discount has been already minus. But there are Cost of Goods Sold, Distribution cost and Warehousing Cost columns that come into the play. so, what will be the Actual total sales? I am stuck here.
@Alex_Hasan , They are negative, you can add up
Total Sales = Sum(Table[Net Sales]) +Sum(Table[Distribution Cost]) +Sum(Table[warehousing Cost])
Thank you so much.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
46 | |
28 | |
22 | |
12 | |
8 |
User | Count |
---|---|
75 | |
52 | |
46 | |
15 | |
12 |