Sales per Month with Year

[sivasrao]

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. just for a brief explanation, I have used the "---" symbol in the target table.

[AbbasG]

@sivasrao  refer to this post here - https://community.powerbi.com/t5/Desktop/How-to-Calculate-sales-by-month/m-p/222960#M99077

[sivasrao]

Thank 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 · Accepted solution]

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.

[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.