Hi Power BI Gurus,
I have below set of data
Now I want an additionla column say SO Instance with value like below, its almost ranking Customer on the base of its SO ID ,Sale ID and Calendar Date
The data has mumtiple customer IDs with respective Sae and SO IDs.
Appreciate yor help in this.
Go to Solution.
Try this calculated column
What is the role of Sale ID in RANKING?
ALL ( TableName ),
TableName[Customer Id] = EARLIER ( TableName[Customer Id] )
&& TableName[Standing Order Id] = EARLIER ( TableName[Standing Order Id] )
check this post
Proud to be a Datanaut! Appreciate your Kudos Feel free to email me with any of your BI needs.
Great it worked like charm... but not surehow ?
May I have to read more article about Earlier...do you have any that explains in detail
This was a little web post I wrote on EARLIER few months back
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.