Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Dear Community !
My data has columns names as the first day of each month (ex: 1/1/2019, 2/1/2019, 3/1/2019 etc) - 12 Columns for an year.
Need your help to figure out how to remove columns whose names DO NOT CONTAIN current year (2023 in this case), however, I don't want to hardcode the year. Currently I am using below, which solves the purpose, by using multiple lines for each year, however, I was looking for one PQ function.
Any help is welcome ! Thanks in advance !
= Table.RemoveColumns(#"Changed Type1",List.FindText(Table.ColumnNames(#"Changed Type1"),"2019"))
Solved! Go to Solution.
User | Count |
---|---|
98 | |
90 | |
77 | |
71 | |
64 |
User | Count |
---|---|
114 | |
97 | |
95 | |
68 | |
65 |