Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Can you provide us demo data???
It's just a series of dates that i'm looking to summarize. The picture in my 1st post without the 2nd column.
Do you use a calendar table???
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.
Sorry but i haven't experience with SSAS models, but it will be easy if you have a calendar table.
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?
NoOfWons = COUNTROWS(Sheet1)
NoOfWonsSPLY = CALCULATE([NoOfWons];SAMEPERIODLASTYEAR(dCalendar[Date]))
the result is :
or you can slice by month and year
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
118 | |
107 | |
70 | |
70 | |
43 |
User | Count |
---|---|
148 | |
104 | |
104 | |
89 | |
66 |