Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I want to fill in the blank with the latest value.
Please help me.
I am a Japanese who can not speak English.
Solved! Go to Solution.
Hi,
What formula are you using for Exchange Value?
Ioana
Hi. Thank you. Exchange Value is tihs table.
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.
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.
Self-solved by adding a query.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
99 | |
73 | |
72 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |