Power Query: Selection of columns with date headers

jajatidev · Nov 30, 2023

Hello All,
I receive an Excel file weekly where the table is already in pivoted format with the below-mentioned headers.
Please advise what do I need to do as a power query step to select the column headers marked in green because the columns with date header is subject to change where past month columns will be retained and new months getting added.

Adoption Manager or CSM

Opportunity Owner (Sales)

Opportunity ID

Opportunity Name

Customer Name

Mfg Part/SKU #

Option Code

Item Description

11/1/2023

12/1/2023

1/1/2024

2/1/2024

3/1/2024

4/1/2024

5/1/2024

6/1/2024

7/1/2024

8/1/2024

9/1/2024

10/1/2024

11/1/2024

12/1/2024

1/1/2025

2/1/2025

3/1/2025

4/1/2025

File Name

Product Type

Sales Stage

PL

NPI EOL Notes

SKU Status

Row Validation

Flexworker SKU

Sales Territory ID

Platform ID

Distributor

Country

Billing Type

SKU + Option Code

ExcelToDAX · Nov 30, 2023

Assuming your table is named Table1, you could do this:

Power Query:

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    Custom1 = Table.ColumnNames(Source),
    #"Converted to Table" = Table.FromList(Custom1, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
    ColumnsToKeep = Table.ToList(Table.SelectRows(#"Converted to Table", each Text.Contains([Column1], "#") or Text.Contains([Column1], "/"))),
    Custom2 = Source,
    #"Removed Other Columns" = Table.SelectColumns(Custom2,ColumnsToKeep)
in
    #"Removed Other Columns"

You get the column names by using Table.ColumnNames, then you convert it to a table. Filter out the columns where they contain "#" and "/", and then convert it back to a list using Table.ToList

Then you create another step referencing the main Source and then use the Remove Other Columns feature and reference the list (which is called ColumnsToKeep in above code)

jajatidev · Dec 1, 2023

ExcelToDAX said:
Assuming your table is named Table1, you could do this:

Power Query:

let Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content], Custom1 = Table.ColumnNames(Source), #"Converted to Table" = Table.FromList(Custom1, Splitter.SplitByNothing(), null, null, ExtraValues.Error), ColumnsToKeep = Table.ToList(Table.SelectRows(#"Converted to Table", each Text.Contains([Column1], "#") or Text.Contains([Column1], "/"))), Custom2 = Source, #"Removed Other Columns" = Table.SelectColumns(Custom2,ColumnsToKeep) in #"Removed Other Columns"

You get the column names by using Table.ColumnNames, then you convert it to a table. Filter out the columns where they contain "#" and "/", and then convert it back to a list using Table.ToList

Then you create another step referencing the main Source and then use the Remove Other Columns feature and reference the list (which is called ColumnsToKeep in above code)

Thank you. Please allow me time to apply the solution and share my findings.

GraH · Dec 1, 2023

Alternative build with UI

Power Query:

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    First_record = Table.First(Source),
    Convert_to_table = Record.ToTable(First_record),
    Set_as_date = Table.TransformColumnTypes(Convert_to_table,{{"Value", type datetime}}),
    Remove_errors = Table.RemoveRowsWithErrors(Set_as_date, {"Value"}),
    Set_as_txt = Table.TransformColumnTypes(Remove_errors,{{"Value", type text}})[Value],
    Promote_headers = Table.PromoteHeaders(Source, [PromoteAllScalars=true]),
    Unpivot_date_cols = Table.Unpivot(Promote_headers, Set_as_txt, "Date", "Value")
in
    Unpivot_date_cols

jajatidev · Dec 1, 2023

GraH said:

Alternative build with UI

Power Query:

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    First_record = Table.First(Source),
    Convert_to_table = Record.ToTable(First_record),
    Set_as_date = Table.TransformColumnTypes(Convert_to_table,{{"Value", type datetime}}),
    Remove_errors = Table.RemoveRowsWithErrors(Set_as_date, {"Value"}),
    Set_as_txt = Table.TransformColumnTypes(Remove_errors,{{"Value", type text}})[Value],
    Promote_headers = Table.PromoteHeaders(Source, [PromoteAllScalars=true]),
    Unpivot_date_cols = Table.Unpivot(Promote_headers, Set_as_txt, "Date", "Value")
in
    Unpivot_date_cols

Hi,
I wasn't able to replicate the solution which could be due to the format of the data I shared. Therefore, to make things easier I'm sharing a sample of the data in the format I receive.
When I get to transform data by promoting the header, the change type step gets automatically added which is the header I shared earlier.



Adoption Manager or CSM	Opportunity Owner (Sales)	Opportunity ID	Opportunity Name	Customer Name	Mfg Part/SKU #	Option Code	Item Description	Nov-23	Dec-23	Jan-24	Feb-24	Mar-24	Apr-24	May-24	Jun-24	Jul-24	Aug-24	Sep-24	Oct-24	Nov-24	Dec-24	Jan-25	Feb-25	Mar-25	Apr-25	File Name	Product Type	Sales Stage	PL	NPI EOL Notes	SKU Status	Row Validation	Flexworker SKU	Sales Territory ID	Platform ID	Distributor	Country	Billing Type	SKU + Option Code
Hardy	Shawn		MCD 2022 PMS	MCD Company	3ZD75D	BZJ		5	5	25	25	20	20	20	20											MCD Company Forecast		06 - Won	GB		Green	Green		354					3ZD75D#BZJ
Hardy	Shawn		MCD 2022 PMS	MCD Company	S7C05D			5	5	25	25	20	20	20	20											MCD Company Forecast		06 - Won	SJ		Green	Green		354					S7C05D
Hardy	Shawn		MCD 2022 PMS	MCD Company	3MS25D	BZJ		10	10	5																MCD Company Forecast		06 - Won	MP		Yellow	Green		354					3MS25D#BZJ
Hardy	Shawn		MCD 2022 PMS	MCD Company	B5E34D			10	10	5																MCD Company Forecast		06 - Won	SQ		Green	Green		354					B5E34D
Hardy	Shawn		MCD 2022 PMS	MCD Company	5ZJ90D	BZJ		19	20	20	20	8														MCD Company Forecast		06 - Won	BG		Green	Green		354					5ZJ90D#BZJ
Hardy	Shawn		MCD 2022 PMS	MCD Company	3ZD35D	BZJ		13	13	13	14															MCD Company Forecast		06 - Won	MP		Green	Green		354					3ZD35D#BZJ

GraH · Dec 3, 2023

jajatidev said:
Hi,
I wasn't able to replicate the solution which could be due to the format of the data I shared. Therefore, to make things easier I'm sharing a sample of the data in the format I receive.
When I get to transform data by promoting the header, the change type step gets automatically added which is the header I shared earlier.

Same query on your shared data does work on my end.
Try with changing the source step to your source. Or share the code you try.



Hardy	Shawn	MCD 2022 PMS	MCD Company	3ZD75D	BZJ	MCD Company Forecast	06 - Won	GB	Green	Green	354	3ZD75D#BZJ	1/11/2023 0:00:00	5
Hardy	Shawn	MCD 2022 PMS	MCD Company	3ZD75D	BZJ	MCD Company Forecast	06 - Won	GB	Green	Green	354	3ZD75D#BZJ	1/12/2023 0:00:00	5
Hardy	Shawn	MCD 2022 PMS	MCD Company	3ZD75D	BZJ	MCD Company Forecast	06 - Won	GB	Green	Green	354	3ZD75D#BZJ	1/01/2024 0:00:00	25
Hardy	Shawn	MCD 2022 PMS	MCD Company	3ZD75D	BZJ	MCD Company Forecast	06 - Won	GB	Green	Green	354	3ZD75D#BZJ	1/02/2024 0:00:00	25
Hardy	Shawn	MCD 2022 PMS	MCD Company	3ZD75D	BZJ	MCD Company Forecast	06 - Won	GB	Green	Green	354	3ZD75D#BZJ	1/03/2024 0:00:00	20
Hardy	Shawn	MCD 2022 PMS	MCD Company	3ZD75D	BZJ	MCD Company Forecast	06 - Won	GB	Green	Green	354	3ZD75D#BZJ	1/04/2024 0:00:00	20
Hardy	Shawn	MCD 2022 PMS	MCD Company	3ZD75D	BZJ	MCD Company Forecast	06 - Won	GB	Green	Green	354	3ZD75D#BZJ	1/05/2024 0:00:00	20
Hardy	Shawn	MCD 2022 PMS	MCD Company	3ZD75D	BZJ	MCD Company Forecast	06 - Won	GB	Green	Green	354	3ZD75D#BZJ	1/06/2024 0:00:00	20
Hardy	Shawn	MCD 2022 PMS	MCD Company	S7C05D		MCD Company Forecast	06 - Won	SJ	Green	Green	354	S7C05D	1/11/2023 0:00:00	5
Hardy	Shawn	MCD 2022 PMS	MCD Company	S7C05D		MCD Company Forecast	06 - Won	SJ	Green	Green	354	S7C05D	1/12/2023 0:00:00	5
Hardy	Shawn	MCD 2022 PMS	MCD Company	S7C05D		MCD Company Forecast	06 - Won	SJ	Green	Green	354	S7C05D	1/01/2024 0:00:00	25
Hardy	Shawn	MCD 2022 PMS	MCD Company	S7C05D		MCD Company Forecast	06 - Won	SJ	Green	Green	354	S7C05D	1/02/2024 0:00:00	25
Hardy	Shawn	MCD 2022 PMS	MCD Company	S7C05D		MCD Company Forecast	06 - Won	SJ	Green	Green	354	S7C05D	1/03/2024 0:00:00	20
Hardy	Shawn	MCD 2022 PMS	MCD Company	S7C05D		MCD Company Forecast	06 - Won	SJ	Green	Green	354	S7C05D	1/04/2024 0:00:00	20
Hardy	Shawn	MCD 2022 PMS	MCD Company	S7C05D		MCD Company Forecast	06 - Won	SJ	Green	Green	354	S7C05D	1/05/2024 0:00:00	20
Hardy	Shawn	MCD 2022 PMS	MCD Company	S7C05D		MCD Company Forecast	06 - Won	SJ	Green	Green	354	S7C05D	1/06/2024 0:00:00	20
Hardy	Shawn	MCD 2022 PMS	MCD Company	3MS25D	BZJ	MCD Company Forecast	06 - Won	MP	Yellow	Green	354	3MS25D#BZJ	1/11/2023 0:00:00	10
Hardy	Shawn	MCD 2022 PMS	MCD Company	3MS25D	BZJ	MCD Company Forecast	06 - Won	MP	Yellow	Green	354	3MS25D#BZJ	1/12/2023 0:00:00	10
Hardy	Shawn	MCD 2022 PMS	MCD Company	3MS25D	BZJ	MCD Company Forecast	06 - Won	MP	Yellow	Green	354	3MS25D#BZJ	1/01/2024 0:00:00	5
Hardy	Shawn	MCD 2022 PMS	MCD Company	B5E34D		MCD Company Forecast	06 - Won	SQ	Green	Green	354	B5E34D	1/11/2023 0:00:00	10
Hardy	Shawn	MCD 2022 PMS	MCD Company	B5E34D		MCD Company Forecast	06 - Won	SQ	Green	Green	354	B5E34D	1/12/2023 0:00:00	10
Hardy	Shawn	MCD 2022 PMS	MCD Company	B5E34D		MCD Company Forecast	06 - Won	SQ	Green	Green	354	B5E34D	1/01/2024 0:00:00	5
Hardy	Shawn	MCD 2022 PMS	MCD Company	5ZJ90D	BZJ	MCD Company Forecast	06 - Won	BG	Green	Green	354	5ZJ90D#BZJ	1/11/2023 0:00:00	19
Hardy	Shawn	MCD 2022 PMS	MCD Company	5ZJ90D	BZJ	MCD Company Forecast	06 - Won	BG	Green	Green	354	5ZJ90D#BZJ	1/12/2023 0:00:00	20
Hardy	Shawn	MCD 2022 PMS	MCD Company	5ZJ90D	BZJ	MCD Company Forecast	06 - Won	BG	Green	Green	354	5ZJ90D#BZJ	1/01/2024 0:00:00	20
Hardy	Shawn	MCD 2022 PMS	MCD Company	5ZJ90D	BZJ	MCD Company Forecast	06 - Won	BG	Green	Green	354	5ZJ90D#BZJ	1/02/2024 0:00:00	20
Hardy	Shawn	MCD 2022 PMS	MCD Company	5ZJ90D	BZJ	MCD Company Forecast	06 - Won	BG	Green	Green	354	5ZJ90D#BZJ	1/03/2024 0:00:00	8
Hardy	Shawn	MCD 2022 PMS	MCD Company	3ZD35D	BZJ	MCD Company Forecast	06 - Won	MP	Green	Green	354	3ZD35D#BZJ	1/11/2023 0:00:00	13
Hardy	Shawn	MCD 2022 PMS	MCD Company	3ZD35D	BZJ	MCD Company Forecast	06 - Won	MP	Green	Green	354	3ZD35D#BZJ	1/12/2023 0:00:00	13
Hardy	Shawn	MCD 2022 PMS	MCD Company	3ZD35D	BZJ	MCD Company Forecast	06 - Won	MP	Green	Green	354	3ZD35D#BZJ	1/01/2024 0:00:00	13
Hardy	Shawn	MCD 2022 PMS	MCD Company	3ZD35D	BZJ	MCD Company Forecast	06 - Won	MP	Green	Green	354	3ZD35D#BZJ	1/02/2024 0:00:00	14

jajatidev · Dec 3, 2023

GraH said:
Same query on your shared data does work on my end.
Try with changing the source step to your source. Or share the code you try.

Hardy Shawn MCD 2022 PMS MCD Company 3ZD75D BZJ MCD Company Forecast 06 - Won GB Green Green 354 3ZD75D#BZJ 1/11/2023 0:00:00 5
Hardy Shawn MCD 2022 PMS MCD Company 3ZD75D BZJ MCD Company Forecast 06 - Won GB Green Green 354 3ZD75D#BZJ 1/12/2023 0:00:00 5
Hardy Shawn MCD 2022 PMS MCD Company 3ZD75D BZJ MCD Company Forecast 06 - Won GB Green Green 354 3ZD75D#BZJ 1/01/2024 0:00:00 25
Hardy Shawn MCD 2022 PMS MCD Company 3ZD75D BZJ MCD Company Forecast 06 - Won GB Green Green 354 3ZD75D#BZJ 1/02/2024 0:00:00 25
Hardy Shawn MCD 2022 PMS MCD Company 3ZD75D BZJ MCD Company Forecast 06 - Won GB Green Green 354 3ZD75D#BZJ 1/03/2024 0:00:00 20
Hardy Shawn MCD 2022 PMS MCD Company 3ZD75D BZJ MCD Company Forecast 06 - Won GB Green Green 354 3ZD75D#BZJ 1/04/2024 0:00:00 20
Hardy Shawn MCD 2022 PMS MCD Company 3ZD75D BZJ MCD Company Forecast 06 - Won GB Green Green 354 3ZD75D#BZJ 1/05/2024 0:00:00 20
Hardy Shawn MCD 2022 PMS MCD Company 3ZD75D BZJ MCD Company Forecast 06 - Won GB Green Green 354 3ZD75D#BZJ 1/06/2024 0:00:00 20
Hardy Shawn MCD 2022 PMS MCD Company S7C05D MCD Company Forecast 06 - Won SJ Green Green 354 S7C05D 1/11/2023 0:00:00 5
Hardy Shawn MCD 2022 PMS MCD Company S7C05D MCD Company Forecast 06 - Won SJ Green Green 354 S7C05D 1/12/2023 0:00:00 5
Hardy Shawn MCD 2022 PMS MCD Company S7C05D MCD Company Forecast 06 - Won SJ Green Green 354 S7C05D 1/01/2024 0:00:00 25
Hardy Shawn MCD 2022 PMS MCD Company S7C05D MCD Company Forecast 06 - Won SJ Green Green 354 S7C05D 1/02/2024 0:00:00 25
Hardy Shawn MCD 2022 PMS MCD Company S7C05D MCD Company Forecast 06 - Won SJ Green Green 354 S7C05D 1/03/2024 0:00:00 20
Hardy Shawn MCD 2022 PMS MCD Company S7C05D MCD Company Forecast 06 - Won SJ Green Green 354 S7C05D 1/04/2024 0:00:00 20
Hardy Shawn MCD 2022 PMS MCD Company S7C05D MCD Company Forecast 06 - Won SJ Green Green 354 S7C05D 1/05/2024 0:00:00 20
Hardy Shawn MCD 2022 PMS MCD Company S7C05D MCD Company Forecast 06 - Won SJ Green Green 354 S7C05D 1/06/2024 0:00:00 20
Hardy Shawn MCD 2022 PMS MCD Company 3MS25D BZJ MCD Company Forecast 06 - Won MP Yellow Green 354 3MS25D#BZJ 1/11/2023 0:00:00 10
Hardy Shawn MCD 2022 PMS MCD Company 3MS25D BZJ MCD Company Forecast 06 - Won MP Yellow Green 354 3MS25D#BZJ 1/12/2023 0:00:00 10
Hardy Shawn MCD 2022 PMS MCD Company 3MS25D BZJ MCD Company Forecast 06 - Won MP Yellow Green 354 3MS25D#BZJ 1/01/2024 0:00:00 5
Hardy Shawn MCD 2022 PMS MCD Company B5E34D MCD Company Forecast 06 - Won SQ Green Green 354 B5E34D 1/11/2023 0:00:00 10
Hardy Shawn MCD 2022 PMS MCD Company B5E34D MCD Company Forecast 06 - Won SQ Green Green 354 B5E34D 1/12/2023 0:00:00 10
Hardy Shawn MCD 2022 PMS MCD Company B5E34D MCD Company Forecast 06 - Won SQ Green Green 354 B5E34D 1/01/2024 0:00:00 5
Hardy Shawn MCD 2022 PMS MCD Company 5ZJ90D BZJ MCD Company Forecast 06 - Won BG Green Green 354 5ZJ90D#BZJ 1/11/2023 0:00:00 19
Hardy Shawn MCD 2022 PMS MCD Company 5ZJ90D BZJ MCD Company Forecast 06 - Won BG Green Green 354 5ZJ90D#BZJ 1/12/2023 0:00:00 20
Hardy Shawn MCD 2022 PMS MCD Company 5ZJ90D BZJ MCD Company Forecast 06 - Won BG Green Green 354 5ZJ90D#BZJ 1/01/2024 0:00:00 20
Hardy Shawn MCD 2022 PMS MCD Company 5ZJ90D BZJ MCD Company Forecast 06 - Won BG Green Green 354 5ZJ90D#BZJ 1/02/2024 0:00:00 20
Hardy Shawn MCD 2022 PMS MCD Company 5ZJ90D BZJ MCD Company Forecast 06 - Won BG Green Green 354 5ZJ90D#BZJ 1/03/2024 0:00:00 8
Hardy Shawn MCD 2022 PMS MCD Company 3ZD35D BZJ MCD Company Forecast 06 - Won MP Green Green 354 3ZD35D#BZJ 1/11/2023 0:00:00 13
Hardy Shawn MCD 2022 PMS MCD Company 3ZD35D BZJ MCD Company Forecast 06 - Won MP Green Green 354 3ZD35D#BZJ 1/12/2023 0:00:00 13
Hardy Shawn MCD 2022 PMS MCD Company 3ZD35D BZJ MCD Company Forecast 06 - Won MP Green Green 354 3ZD35D#BZJ 1/01/2024 0:00:00 13
Hardy Shawn MCD 2022 PMS MCD Company 3ZD35D BZJ MCD Company Forecast 06 - Won MP Green Green 354 3ZD35D#BZJ 1/02/2024 0:00:00 14

Here are the steps

Power Query:

let
    Source = Excel.Workbook(), null, true),
    Data_Sheet = Source{[Item="Data",Kind="Sheet"]}[Data],
    #"Changed Type" = Table.TransformColumnTypes(Data_Sheet,{{"Column1", type text}, {"Column2", type text}, {"Column3", type text}, {"Column4", type text}, {"Column5", type text}, {"Column6", type text}, {"Column7", type text}, {"Column8", type text}, {"Column9", type any}, {"Column10", type any}, {"Column11", type any}, {"Column12", type any}, {"Column13", type any}, {"Column14", type any}, {"Column15", type any}, {"Column16", type any}, {"Column17", type any}, {"Column18", type any}, {"Column19", type any}, {"Column20", type any}, {"Column21", type any}, {"Column22", type any}, {"Column23", type any}, {"Column24", type any}, {"Column25", type any}, {"Column26", type any}, {"Column27", type text}, {"Column28", type text}, {"Column29", type text}, {"Column30", type text}, {"Column31", type text}, {"Column32", type text}, {"Column33", type text}, {"Column34", type text}, {"Column35", type text}, {"Column36", type any}, {"Column37", type text}, {"Column38", type text}, {"Column39", type text}, {"Column40", type text}}),
    #"Promoted Headers" = Table.PromoteHeaders(#"Changed Type", [PromoteAllScalars=true]),
    #"Changed Type1" = Table.TransformColumnTypes(#"Promoted Headers",{{"Adoption Manager or CSM", type text}, {"Opportunity Owner (Sales)", type text}, {"Opportunity ID", type text}, {"Opportunity Name", type text}, {"Customer Name", type text}, {"Mfg Part/SKU #", type text}, {"Option Code", type text}, {"Item Description", type text}, {"11/1/2023", Int64.Type}, {"12/1/2023", Int64.Type}, {"1/1/2024", Int64.Type}, {"2/1/2024", Int64.Type}, {"3/1/2024", Int64.Type}, {"4/1/2024", Int64.Type}, {"5/1/2024", Int64.Type}, {"6/1/2024", Int64.Type}, {"7/1/2024", Int64.Type}, {"8/1/2024", Int64.Type}, {"9/1/2024", Int64.Type}, {"10/1/2024", Int64.Type}, {"11/1/2024", Int64.Type}, {"12/1/2024", Int64.Type}, {"1/1/2025", Int64.Type}, {"2/1/2025", Int64.Type}, {"3/1/2025", Int64.Type}, {"4/1/2025", Int64.Type}, {"File Name", type text}, {"Product Type", type text}, {"Sales Stage", type text}, {"PL", type text}, {"NPI EOL Notes", type text}, {"SKU Status", type text}, {"Row Validation", type text}, {"Flexworker SKU", type text}, {"Sales Territory ID", Int64.Type}, {"Platform ID", type any}, {"Distributor", type text}, {"Country", type text}, {"Billing Type", type text}, {"SKU + Option Code", type text}})

in
    #"Changed Type1"

GraH · Dec 3, 2023

You can try with this.

Power Query:

let
    Source = Excel.Workbook(), null, true),
    Data_Sheet = Source{[Item="Data",Kind="Sheet"]}[Data],
    First_record = Table.First(Data_Sheet),
    Convert_to_table = Record.ToTable(First_record),
    Set_as_date = Table.TransformColumnTypes(Convert_to_table,{{"Value", type datetime}}),
    Remove_errors = Table.RemoveRowsWithErrors(Set_as_date, {"Value"}),
    Set_as_txt = Table.TransformColumnTypes(Remove_errors,{{"Value", type text}})[Value],
    Promote_headers = Table.PromoteHeaders(Data_Sheet, [PromoteAllScalars=true]),
    Unpivot_date_cols = Table.Unpivot(Promote_headers, Set_as_txt, "Date", "Value")
in
    Unpivot_date_cols

jajatidev · Dec 4, 2023

GraH said:

You can try with this.

Power Query:

let
    Source = Excel.Workbook(), null, true),
    Data_Sheet = Source{[Item="Data",Kind="Sheet"]}[Data],
    First_record = Table.First(Data_Sheet),
    Convert_to_table = Record.ToTable(First_record),
    Set_as_date = Table.TransformColumnTypes(Convert_to_table,{{"Value", type datetime}}),
    Remove_errors = Table.RemoveRowsWithErrors(Set_as_date, {"Value"}),
    Set_as_txt = Table.TransformColumnTypes(Remove_errors,{{"Value", type text}})[Value],
    Promote_headers = Table.PromoteHeaders(Data_Sheet, [PromoteAllScalars=true]),
    Unpivot_date_cols = Table.Unpivot(Promote_headers, Set_as_txt, "Date", "Value")
in
    Unpivot_date_cols

Thank you, GraH.
The solution works as expected. However, after comparison, I'm more comfortable using the one proposed by ExceltoDAX.

GraH · Dec 4, 2023

jajatidev, that's fair enough.

Power Query: Selection of columns with date headers

jajatidev

Board Regular

Excel Facts

ExcelToDAX

Board Regular

jajatidev

Board Regular

GraH

Well-known Member

jajatidev

Board Regular

GraH

Well-known Member

jajatidev

Board Regular

GraH

Well-known Member

jajatidev

Board Regular

GraH

Well-known Member

Similar threads

Forum statistics

Share this page

Power Query: Selection of columns with date headers

Board Regular

Excel Facts

Board Regular

Board Regular

Well-known Member

Board Regular

Well-known Member

Board Regular

Well-known Member

Board Regular

Well-known Member

Similar threads

Forum statistics

Share this page

We've detected that you are using an adblocker.

Which adblocker are you using?

Disable AdBlock

Disable AdBlock Plus

Disable uBlock Origin

Disable uBlock