Forum Discussion
sivasrao
Helper III
Helper IIISales per Month with Year
Hi All, How can I calculate the year-wise "Sales per Month"? The below table is the source table. The Target Table is Thank you in advance. Note: "---" means the value is present...
Finally, I got a logic for this requirement.
Step 1:
Month Year = FORMAT(sales(Sales Date),"mmm-yyyy")
Step 2:
SalesPerMonth = CALCULATE(SUM(Sales[Amount]),FILTER('Sales',(Sales[Month Year]=EARLIER(Sales[Month Year]))))Thank you for all.Note: This is a new Column only. Not a measure.
AbbasG
Memorable Member
Memorable Membersivasrao refer to this post here - https://community.powerbi.com/t5/Desktop/How-to-Calculate-sales-by-month/m-p/222960#M99077
sivasraoThank you. It is working.
Is there any chance to create "sales per month" as a new column? what is the logic for that?
Output like,
- sivasrao
I used this logic,
But I am getting total sales per month irrespective of year.It means, getting the same value in May 2018 and May 2019, Aug 2018 and Aug 2019, etc. - sivasrao
Finally, I got a logic for this requirement.
Step 1:
Month Year = FORMAT(sales(Sales Date),"mmm-yyyy")
Step 2:
SalesPerMonth = CALCULATE(SUM(Sales[Amount]),FILTER('Sales',(Sales[Month Year]=EARLIER(Sales[Month Year]))))Thank you for all.Note: This is a new Column only. Not a measure.