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.
Table 1 has column of data (4 rows) and I tranpose this data into a sigle row.
I append this query to another table and then want to fill "up or down" this appended data.
The formula looks like this:
= Table.FillUp(#"Appended Query",{"Column1", "Column2", "Column3", "Column4"})
If I add more rows to Table 1 (go from 4 rows to "N" number of rows), how do I get the Fill command to dynamically select the updated number of colmuns?
Is there a way to select the range of colums like the following:
= Table.FillUp(#"Appended Query",{"Column1" : "ColumnN"})
Thanks for the help in advance I really appreciate it!
Solved! Go to Solution.
Hi - Try Below.
Table.FillDown(#"Appended Query",Table.ColumnNames(#"Appended Query"))
Thanks
Ankit Jain
Do Mark it as solution if the response resolved your problem. Do like the response if it seems good and helpful.
Hi - Try Below.
Table.FillDown(#"Appended Query",Table.ColumnNames(#"Appended Query"))
Thanks
Ankit Jain
Do Mark it as solution if the response resolved your problem. Do like the response if it seems good and helpful.
Excellent suggestion! Its exatcly what I needed! Thank you!
@AnkitBI wrote:Hi - Try Below.
Table.FillDown(#"Appended Query",Table.ColumnNames(#"Appended Query"))Thanks
Ankit JainDo Mark it as solution if the response resolved your problem. Do like the response if it seems good and helpful.
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.