Forum Discussion
Solved
Order Rank on Sales Data
Hi, I'm struggling to add a new column to my dataset using a dax calculated column. I want it to look something similar to this: Columns A-D are in my dataset, and I want it to have ...
- Rank= RANKX(FILTER(all('Rank'),'Rank'[email]=EARLIER('Rank'[email])),'Rank'[date],,ASC,Dense)Regards,Ritesh
Regards,
Ritesh
Mark my post as a solution if it helped you| Munde and Kudis (Ladies and Gentlemen) I like your Kudos!! !!
My YT Channel Dancing With Data !! Connect on Linkedin !!Power BI for Tableau Users Hi,
Write this calculated column formula
Order rank = calculate(countrows(Data),filter(Data,Data[Email]=earlier(Data[Email])&&Data[payment date]=earlier(Data[payment date])))
Hope this helps.
Rank= RANKX(FILTER(all('Rank'),'Rank'[email]=EARLIER('Rank'[email])),'Rank'[date],,ASC,Dense)
Regards,
Ritesh
Regards,
Ritesh
Mark my post as a solution if it helped you| Munde and Kudis (Ladies and Gentlemen) I like your Kudos!! !!
My YT Channel Dancing With Data !! Connect on Linkedin !!Power BI for Tableau Users