cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper II
Helper II

Month on Month Rank Comparison

Hi,

If you could also help me with Month on Month Rank change DAx.. My rank is changing month on month basis for same group.

 

I want to create a measure for Trend and check the Rank difference of this month to last month  (Trend)

 

Last Month Ranking

MonthUnitDivison Ranking checkAverage of Star Rating
FebGroup1213
FebGroup1122.76
FebGroup1032.62
FebGroup942.57
FebGroup852.36
FebGroup762.33
Feb 72.29
FebGroup582.22
FebGroup492.11
Feb 102.06
FebGroup1112
FebGroup2111.95
FebGroup3121.8
FebTBA13 

 

This month ranking

MonthUnitDivison Ranking checkTrend
MarGroup121312
MarGroup1175
MarGroup1041
MarGroup93-1
MarGroup83-2
MarGroup73-3
Mar 4-3
MarGroup5102
MarGroup42-7
Mar 9-1
MarGroup19-2
MarGroup28-3
MarGroup39-3
MarTBA4-9

 

Tend is representing this month to last month rank difference.. I am new in powerbi so not able to apply the Time intellegence function.. 

@harshnathani @Pragati11 

 

Please help.

 

Regards

Uphar

2 REPLIES 2
Highlighted
Helper II
Helper II

Re: Month on Month Rank Comparison

Hi @harshnathani , @Greg_Deckler , @Pragati11 , @Mariusz , @amitchandak 

 

Could you please look into the threat. Need your help guys.

 

Regards

Uphar

Highlighted
Super User IV
Super User IV

Re: Month on Month Rank Comparison

@Uphartandon , please try like this example. I have not tested this

MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD('Date'[Date]))
last MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(dateadd('Date'[Date],-1,MONTH)))


MTD RANK = Rankx(all(Table[Unit],Table[Divison]),[MTD Sales],,desc,dense)
LMTD RANK = Rankx(all(Table[Unit],Table[Divison]),[last MTD Sales],,desc,dense)

Diff =[MTD RANK] -[LMTD RANK]

 

To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :
https://radacad.com/creating-calendar-table-in-power-bi-using-dax-functions
https://www.archerpoint.com/blog/Posts/creating-date-table-power-bi
https://www.sqlbi.com/articles/creating-a-simple-date-table-in-dax/

See if my webinar on Time Intelligence can help: https://community.powerbi.com/t5/Webinars-and-Video-Gallery/PowerBI-Time-Intelligence-Calendar-WTD-Y...


Appreciate your Kudos.



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Helpful resources

Announcements
Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors