Aggregate by month: This year & last year for graph representation

[dannn777]

Hi,

I am using a live connection to an SSAS model.

I am trying to graph 2 measures - won this year and won last year for a graph. Obviously with the series being the month name.

I have 2 dax measures creating the totals for this year vs last year which seem to work correctly on their own.

wonThisYear = countrows(filter(Table, Table[WonDate]>date(year(TODAY()), 1, 1))) 

wonLastYear = countrows(filter(Table, Table[WonDate]>date(year(TODAY())-1, 1, 1) && Table[WonDate] <= date(YEAR(TODAY())-1,12,31)))

However in table view it seems to show 1 entry per date rather than aggregating the dates together. E.g.

This also graphs horribly:

The aspiration is something like this:

Any guidance appreciated.

[sokg]

Can you provide us demo data???

[dannn777]

It's just a series of dates that i'm looking to summarize. The picture in my 1st post without the 2nd column.

[sokg]

Do you use a calendar table???

[dannn777]

I'm connecting to a SSAS model which is the pure data source. I don't have the facility to create new tables either in the model or powerBI because of the live connection.

[sokg]

Sorry but i haven't experience with SSAS models, but it will be easy if you have a calendar table.

[dannn777]

I can probably get a calendar table created for use in the model which I understand should function the same. Can you advise how I can accomplish this with a calendar table?

[sokg]

NoOfWons = COUNTROWS(Sheet1)

NoOfWonsSPLY = CALCULATE([NoOfWons];SAMEPERIODLASTYEAR(dCalendar[Date]))

the result is :

[sokg]

or you can slice by month and year