Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
I have a table exported from Power BI and attached here It has with multiple bandwidths and multiple terms on each record. I need to find the lowest bandwidth and longest term for each record so I can report on the mrc quoted. How do I approach this in Power BI?
In the example table, I have some records where the fields I need to find are highlighted in yellow and the corresponding field I would report is highlighted in green.
As an added twist, there are cases where we no bid certain bandwidths or terms - I have the values highlighted in pink on one such record.
Any help will be greatly appreciated!
Solved! Go to Solution.
I found the "Unpivot Columns" funtionality that enabled me to analyze the data in columns rather than rows. This is what was needed. Everyone else probably knew about this but it was new to me!
Hi @barbforsman,
Can you mark the proper answer as a solution please?
Best Regards,
Dale
I found the "Unpivot Columns" funtionality that enabled me to analyze the data in columns rather than rows. This is what was needed. Everyone else probably knew about this but it was new to me!
Hi @barbforsman,
Since your data is quite rough, there could be much work to do. Please refer to the attachment for details.
BTW, don't post private data here unless you can do it.
Best Regards,
Dale
User | Count |
---|---|
84 | |
77 | |
76 | |
43 | |
36 |
User | Count |
---|---|
109 | |
56 | |
52 | |
45 | |
43 |