have a little trouble in added rankx to the current measure...so the 1/7/2019 is value 1 and the oldest date 36..
Table 2 = ADDCOLUMNS(FILTER(CALENDAR(MIN(PMS_FINANCIAL_PDS[Month Start]),MAX(PMS_FINANCIAL_PDS[Month Start])),DAY([Date]) =1),
FILTER(PMS_FINANCIAL_PDS,PMS_FINANCIAL_PDS[Month Start].[Year] = YEAR(EARLIER([Date]))
&& PMS_FINANCIAL_PDS[Month Start].[MonthNo] = MONTH(EARLIER([Date]))))+0)
Go to Solution.
Hi Xiaoxin Sheng
I have managed to solve the problem using the following DAX and Amend my orginial DAX formula. Much Appericated for all the support you guy provide.
Hi @Route217 ,
If you can please share some sample data with expected result, it will be help for test and coding formula.
How to Get Your Question Answered Quickly
Sorry for late response, I try to access your link but it seems expired. Can you please renew and share it?Regards,
Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.
We spoke with Power BI Super User, Greg Deckler, about his charity work
Continue your learning in our online communities.