Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
I am tying to find bottom two. It can be dax or power query functions in Columns that'tells if it true /false for 1 and 2 below
1) top 10 column1 values regading to each month and highest price, should contain all values from column B with respect to column1 ( So for ABC , if row price is in top 10 in month JAN column2 with have 123 and 234)
2) out of above result I need to find value in column2 which has highest price with repect to each column1 (So for ABC column2 will be 123)
Column1 Column2 Price Month
Abc 123 $2343 jan
bcd 234 $1232 jan
abc 234 $2000 Feb
abc 234 $2100 Jan
cde 345 $5000 Jan
cde 345 $2300 Jan
@g_js your requirement is not at all clear to me. What is column A?? What you are trying to achieve? Can you provide more detailed information with the expected output?
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Sorry I mean column1 from table below
User | Count |
---|---|
66 | |
60 | |
47 | |
33 | |
32 |
User | Count |
---|---|
87 | |
72 | |
56 | |
49 | |
45 |