cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Eiji77 Helper II
Helper II

I want to fill in the blank with the latest value

rate.png

I want to fill in the blank with the latest value.

Please help me.

I am a Japanese who can not speak English.

1 ACCEPTED SOLUTION

Accepted Solutions
Eiji77 Helper II
Helper II

Re: I want to fill in the blank with the latest value

Self-solved by adding a query.

View solution in original post

5 REPLIES 5
avramioana Helper I
Helper I

Re: I want to fill in the blank with the latest value

Hi, 

 

What formula are you using for Exchange Value?

 

Ioana

Eiji77 Helper II
Helper II

Re: I want to fill in the blank with the latest value

無題.pngHi. Thank you. Exchange Value is tihs table.

Highlighted
avramioana Helper I
Helper I

Re: I want to fill in the blank with the latest value

if the column is in your source data then in Edit Queries, sort the data after Exchange Date and go to Transform tab, use Fill option, with fill Down.Fill Down option Power BI.PNG

 

 

Eiji77 Helper II
Helper II

Re: I want to fill in the blank with the latest value

Thank you for answering. Sorry, the Exchange table has no Exchange date if there is no Exchange value. The image is as follows. Therefore, I can not fill in the query. I want to enter the latest Exchange value for dates in the calendar table although there is no Exchange date.

無題.png

Eiji77 Helper II
Helper II

Re: I want to fill in the blank with the latest value

Self-solved by adding a query.

View solution in original post

Helpful resources

Announcements
‘Better Together’ T-Shirt Contest – Winner Announced!

‘Better Together’ T-Shirt Contest – Winner Announced!

And the winner is...

Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

April 2020 Community Highlights

April 2020 Community Highlights

Info on our Super Users, MBAS content and badges, and updates to our support articles. - Read the full Community Highlights.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

Top Solution Authors
Top Kudoed Authors