EXPRESSION ERROR IN POWER QUERY

[GAURAV SEMWAL]

 

[RoryA]

Your field is called DATE not Date. Power query's code is case-sensitive.

 

[GAURAV SEMWAL]

HOW I can fix this error.

Your field is called DATE not Date. Power query's code is case-sensitive.

thank you sir for the reply
and i have already placed a name of cell "Date"
as shown in screenshot.

 

[RoryA]

I'm not talking about the name of the cell. In your first post, in the pictures the first column header is DATE not Date. Since you haven't given any indication what the query actually is, all we can do is guess at the possible cause from your pictures.

 

[GAURAV SEMWAL]

sir this is vba code to fetch the data with the help power query after changing the date in yellow highlighted part is for Date selection.

in below image highlighted green colour is a original link.

 

[RoryA]

What is GetDate?

 

[GAURAV SEMWAL]

 

[RoryA]

Your named range does not have a header, so you should use GetDate{0}[Column1]

 

[GAURAV SEMWAL]

THANK YOU SIR GOT THE SOLUTION.

 

[RoryA]

Glad we could help.