Forum Discussion
Find Nth minimum and do some recalculations
Community ChampionMichael_nik It's hard to say exactly with the information provided. If the rank is static then you could do it in a DAX calculated column. If it needs to be dynamic, you can do it using ADDCOLUMNS in a measure.
Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882
Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.
Sorry for misleading you, I'm just new to Power BI and this forum, I know much more about python.
This is main table (sample dataset from Power BI library):
If I got you straight, I need to add column with DAX formula in it containing RANKX(...).
What I need is a table where there is product name and its 5th min price (like this):
Product ----- 5th price
Montana ---- 10
VTT --------- 15
Amarilla ---- 20
Numbers are random just for this example. Sorry that I had to insert table like this, because table icon in message doesnt work and html error appears.
So after I get this table, the only thing to do is to find the savings for the Client in the main table.
Thank you for your time, Mike