Need Difference of next month to selected month using dax

[avulasandeep]

HI PowerBI Experts ,

need the dax formula for the selected with previous month or year seelction  for salesand Purchase for the selected year or month .

Here is the Screenshoot for more details. can any one help out from this .

Can anyone solve this using dax . this would be more helpful .

Thanks in Advance,

Thanks 

Sandeep  

[v-frfei-msft · Accepted solution]

Hi @avulasandeep ,

Update the measure.

Measure = CALCULATE(SUM(Table1[Sales]),FILTER(ALL(Table1),Table1[MonthNo]=MAX(Table1[MonthNo])+1))-CALCULATE(SUM(Table1[Purchase]))

Regards,

Frank

[v-frfei-msft · Accepted solution]

Hi @avulasandeep ,

Update the measure.

Measure = CALCULATE(SUM(Table1[Sales]),FILTER(ALL(Table1),Table1[MonthNo]=MAX(Table1[MonthNo])+1))-CALCULATE(SUM(Table1[Purchase]))

Regards,

Frank

[v-frfei-msft · Accepted solution]

Hi @avulasandeep ,

Does that make sense? If so, kindly mark my answer as the solution to close the case please. Thanks in advance.

Regards,
Frank

[v-frfei-msft]

Hi @avulasandeep ,

1. Create a calculated column as below.

MonthNo = SWITCH(Table1[Month],"January",1,"February",2,"March",3,"April",4,"May",5,"June",6,"July",7,"August",8,"September",9,"October",10,"November",11,"December",12)

2. Create a measure to get the result we need.

Measure = CALCULATE(SUM(Table1[Sales]))- CALCULATE(SUM(Table1[Purchase]),FILTER(ALL(Table1),Table1[MonthNo]=MAX(Table1[MonthNo])-1))

Regards,

Frank

[avulasandeep]

Hi ,

Please read the question what I need , here I need the solution for multiple years selected that output should be sales of selected month - previous month purchases. But the above formula is getting output as selected month -1 only what about the sales of the selected month - previous month selected value how to get that????
Please let me know any questions...?

Thanks
Sandeep