Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
I'm trying to set first row to a column header but when new data is added (a new column) there's null values until the new column name. How do i set this new column name/ is there a way i can tell it to ignore the NULL rows and just set the first non NULL record to column header?
eg please see example below:
How would I set the MS word in this example as a header?
Thanks in advance 🙂
Chris
You may take advantage of Table.FillUp.
#"Filled Up" = Table.FillUp(Source, Table.ColumnNames(Source)), #"Kept First Rows" = Table.FirstN(#"Filled Up",1), #"Removed Top Rows" = Table.Skip(Source,1), #"Appended Query" = Table.Combine({#"Kept First Rows", #"Removed Top Rows"})
Hi @v-chuncz-msft,
Thanks for your help, I'm getting a stuck on an error do you know what is causing this?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |