Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
Porkey
Frequent Visitor

Need help inserting specific date from same row into the table

Porkey_1-1688654407134.png

 

I want to insert the date from row 1 into the Table on row one, the code ive used has inserted the dates as a list so they are all present. Is there a waty to get just the date from that row into the table?

 

Table.AddColumn(
                #"Invoked Custom Function", 
                "Custom", 
                 each Table.AddColumn(
                                       [ContentAdder],  
                                       "Date",
                                        each #"Invoked Custom Function"[Date],
                                        type date
                                       )
                )

 

edit: the date comes from the file name

1 ACCEPTED SOLUTION
edhans
Super User
Super User

You need to trap that value (date) in a variable first, then reference the variable inside the Table.AddColumn. Something like this:

 

Table.AddColumn(
                #"Invoked Custom Function", 
                "Custom", 

                 each 
				 	let
						varDate = [Date]
					in
					Table.AddColumn(
                                       [ContentAdder],  
                                       "Date",
                                        each varDate,
                                        type date
                                       )
                )


Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting

View solution in original post

4 REPLIES 4
AlienSx
Super User
Super User

Table.AddColumn(
    #"Invoked Custom Function", 
    "Custom", 
    (x) => 
        Table.AddColumn(
            x[ContentAdder],  
            "Date",
            (y) => x[Date],
            type date
        )
)
edhans
Super User
Super User

You need to trap that value (date) in a variable first, then reference the variable inside the Table.AddColumn. Something like this:

 

Table.AddColumn(
                #"Invoked Custom Function", 
                "Custom", 

                 each 
				 	let
						varDate = [Date]
					in
					Table.AddColumn(
                                       [ContentAdder],  
                                       "Date",
                                        each varDate,
                                        type date
                                       )
                )


Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting
Porkey
Frequent Visitor

Thank you very much. 
Can i ask why it needs to be trapped in a variable? or if you cold point me to some reading that would explain.

 

 

In trapping the variable the way I did, I got the value outside of the context of the next Table.AddColumn() function. You can read more about it here. M Language basic concepts - PowerQuery M | Microsoft Learn

But it is similar to using a variable in DAX to trap values at an outer context vs using EARLIER() in the inner context. 



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel1

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

Top Solution Authors
Top Kudoed Authors