Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello,
Is there any way that the blank columns will just copy the previous number? This one is directly connected to a web source so I'm thinking just to create a new column for Total Distributed per 100k and blanks will copy the number of the previous date.
For example January 16, 17, 18 Total Distributed per 100k will be 9,523.97 same as January 15.
In this way, I can normalized the 7 day rolling average.
Herein on this link the pbi file.
https://drive.google.com/file/d/1HLKbdqZgTLd5nWxYzery0g2slMQmKpht/view?usp=sharing
Solved! Go to Solution.
in Power Query Editor -> Transform Tab -> Fill ->Down option will help you to copy the previous cell value to all blanks below. Try that
Proud to be a Super User!
in Power Query Editor -> Transform Tab -> Fill ->Down option will help you to copy the previous cell value to all blanks below. Try that
Proud to be a Super User!
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |