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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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

Self-solved by adding a query.

View solution in original post

5 REPLIES 5
Anonymous
Not applicable

Hi, 

 

What formula are you using for Exchange Value?

 

Ioana

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

Anonymous
Not applicable

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

 

 

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

Self-solved by adding a query.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.