How to Calculate sales by month

[Sac]

Id    Sale           Date

1      $5               01/02/2017

2      $6              01/02/2017

3       $13              01/02/2017

4       $32              05/02/2016

5       $23              05/02/2016

I want Output like below:

Febuary 2017    Febuary 2016

$24                      $55

[vanessafvg]

@Sac

i would start with creating a date table

https://www.mattmasson.com/2014/02/creating-a-date-dimension-with-a-power-query-script/

then create a relationship between your date and the table date

then create  measure call total sales

total sales = sum(sale)

[Sac]

Dear,

Thank you for solution but it is not working for me. i already tried this one before. Do you have any other that best fit in power bi ?

[vanessafvg]

@Sac what do you mean by its not working for you? be specific with what the problem is

[Sac]

I create date and load my data .then make relationship between it.

Then i write this function:

totalsales = SUM(Master[Freight Charge]).

Its give me only total cost , not month by month . 

[BhaveshPatel · Accepted solution]

Hi Sac,

you should Create a MonthYear Column in your table and drag that onto the visaul along with measure to see the correct results.

[Cifuldementa]

HI Your solution works (apart from "mmmm" which throws error), but the problem of the chronological order in the graph remains. Obviously ordering on the date constructed as you indicate leads to an incongruous result (e.g. 2022-1 / 2022-10 ...). Is there a way to sort chronologically correctly?

example

[fuqmicrosoft]

This isn't working for me.  Here's what I get step by step:

1- Add month

add month

2 - Add november and october from their repsective tables:

For some reason every month keeps fanning out to the right rather than just being a row in the same column.  Why does it do this? super annoying...

[Sac]

Thank you. Its work for me