Forum Discussion
total Sales
Hi Please help with results wich is have in pivote of attached file Saple data
Anonymous
Apart from the Calendar table, you can create two measures:
Total Sales(m) = SUM(Sales[Total Sales]))
Total Profit(m) = SUM(Profits[Profits])
Cheers!
Vivek
If it helps, please mark it as a solution
Kudos would be a cherry on the top 🙂
https://www.vivran.in/
Connect on LinkedIn
Could you please share DAX for this? If possible
Anonymous
Apart from the Calendar table, you can create two measures:
Total Sales(m) = SUM(Sales[Total Sales]))
Total Profit(m) = SUM(Profits[Profits])
Cheers!
Vivek
If it helps, please mark it as a solution
Kudos would be a cherry on the top 🙂
https://www.vivran.in/
Connect on LinkedIn