Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi Folks!!
I have a excel source file with three columns as shown.
ColA | Name | Address |
Col A name will change every day, say JAN, FEB etc, there is no exact fixed pattern of change in column name, it can be any Month name any time.
I want to capture this name of column in any variable say varA.
I have tried to use Parameter but parameter value is not chaning by its own even source got refreshed, i can understand, in Parameter we need to change value manually.
Is there any way out to capture the value of column in varA and that variable can be utilised further.
Thanks
Amit Srivastava
Solved! Go to Solution.
You can use Table.ColumnNames(#"Previous Step"){0} to get the name of the first column dynamically and use that wherever you would have used the text name of the column. Replace #"Previous Step" with the appropriate step name.
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
You can use Table.ColumnNames(#"Previous Step"){0} to get the name of the first column dynamically and use that wherever you would have used the text name of the column. Replace #"Previous Step" with the appropriate step name.
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.