Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! It's time to submit your entry. Live now!

Reply
DavidB023
Helper III
Helper III

First Value

‎03-29-2018 05:12 AM

Hi everybody !

 

I just need to create a column in a table from the first value of another column from many tables.

 

In fact, I used Switch function but I have some difficulties with the first value selection. I try MAX but I have figures and texts in the same column. I try  FIRSTNONBLANK but when I actualize my data, function don't take the first value but the second...

 

Best regards

David

Labels:
Message 1 of 2
430 Views
0
1 REPLY 1
Anonymous
Not applicable

‎03-30-2018 02:23 AM

@DavidB023,

Please share dummy data of your tables and post expected result here.

Regards,
Lydia

Message 2 of 2
405 Views
0

Helpful resources

Announcements
December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

View All