Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I need to create a column that fetches the last non-blank value as an example.
Initial data:
Column that i need to create:
Yellow column it's the goal, green column is to exemplify the logic, if the column "Avaliação Final" have data, i use that data, if the follow rows doesn't have, i use the previous data available.
Thanks
Hugo
Solved! Go to Solution.
For fun only, a showcase of powerful Excel formulas,
Expertise = List.Accumulate( {Days as from Today}, {Skills and Knowledge}, (Current, Everyday) => Current & Day.LeanAndPractise(Everyday) ) |
I forgot to mention that i also need to filter by customer, i need the previous status by cliente too:
I forgot to mention that i also need to filter by customer, i need the previous status by cliente too:
User | Count |
---|---|
97 | |
85 | |
77 | |
66 | |
62 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
58 |