Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! It's time to submit your entry. Live now!
I need to test if the first header of my source file is a specific value. Or how do you get the value of the first header so I can compare it to a specific value
Thank you
Solved! Go to Solution.
This works
headers = Table.ColumnNames(#"Trimmed Text") as list,
headersContain = List.Contains(headers, "First Name")
This works
headers = Table.ColumnNames(#"Trimmed Text") as list,
headersContain = List.Contains(headers, "First Name")
| User | Count |
|---|---|
| 18 | |
| 13 | |
| 9 | |
| 8 | |
| 7 |