Forum Discussion
Fill blank cells with previous value with DAX formula
Hello. I need to create a column where I can fill the empty cells with the previous value.
Chris123Terr maybe easier if you create this table in PQ and then take advantage of Fill Down to fill the missing year value from the previous year.
✨ Follow us on LinkedIn and to our YouTube channel
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.
1 Reply
- parry2k
Super User
Chris123Terr maybe easier if you create this table in PQ and then take advantage of Fill Down to fill the missing year value from the previous year.
✨ Follow us on LinkedIn and to our YouTube channel
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.