Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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 |
---|---|
83 | |
76 | |
71 | |
68 | |
54 |
User | Count |
---|---|
105 | |
100 | |
91 | |
79 | |
68 |