Forum Discussion

basrooz's avatar
basrooz
Icon for Advocate I rankAdvocate I
3 years ago

Percentile in column

Hi, I have a table with clients, the amount of orders, and the average amount of orders per month.   Client ID Country Orders Average orders per month A USA 100 3 B...
Need Help
v-yueyunzh-msft's avatar
v-yueyunzh-msft
Icon for Community Support rankCommunity Support
3 years ago

Hi, basrooz 

Based on your description, you want to create two calculated columns. Right?

For your needs, I'm sorry, I don't understand your Percentile's computational logic.

If you want to group based on Country, you can use FILTER() in combination with the EARLIER() function to implement grouping in a calculated column.

You can describe your calculation logic in detail, or you can provide us with your DAX formula so that we can better help you.

 

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly