Gauge max value to "best month sales in current year"

[unclejemima]

I'm using a few measures to calculate "IncomeLastMonth" and "IncomeThisMonth" (full month)

IncomeLastMonth = SUMX(FILTER(Trandata,EOMONTH(Trandata[EndofMonthDate],0)=EOMONTH(NOW(),-1)),Trandata[Income4000's])

IncomeThisMonth = SUMX(FILTER(Trandata,EOMONTH(Trandata[EndofMonthDate],0)=EOMONTH(NOW(),0)),Trandata[Income4000's])

So...I have the IncomeThisMonth as the VALUE of the gauge, the IncomeLast Month as the TARGET, and I want to make a calculation for the "BestFullMonthThisCurrentYear"

Any idea what DAX I could use for this?

Thanks!

[Ashish_Mathur]

Hi,

Try this measure

=MAXX(SUMMARIZE(VALUES(Trandata[EndofMonthDate]),[EndofMonthDate],"ABCD",SUM(Trandata[Income4000's])),[ABCD])

Hope this helps.

[unclejemima]

Thanks for the reply.

I was returned a result what was the sales for the entire calender year, less the current month, not the best sales month in the current year.

Any other idea's?

[Ashish_Mathur]

Hi,

Show the link from where i can download your PBI file and also show the expected result.