Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
User | Count |
---|---|
141 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
123 | |
101 | |
71 | |
61 |