Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
barbforsman
Resolver I
Resolver I

How to find the value of a field in a record based on the values of two other fields in the same rec

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!

1 ACCEPTED 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!

View solution in original post

3 REPLIES 3
v-jiascu-msft
Microsoft Employee
Microsoft Employee

Hi @barbforsman,

 


Can you mark the proper answer as a solution please?

 

Best Regards,

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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!

v-jiascu-msft
Microsoft Employee
Microsoft Employee

Hi @barbforsman,

 

Since your data is quite rough, there could be much work to do. Please refer to the attachment for details.

How_to_find_the_value_of_a_field_in_a_record_based_on_the_values_of_two_other_fields_in_the_same

 

BTW, don't post private data here unless you can do it.

 

Best Regards,

Dale

 

 

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.