Forum Discussion
mdex
Resolver I
Resolver ILast Non Null Value by Month
I have a table like the below. What I want to be able to do is return the last 'Total' value per month, some rows may be blank. Date UK SA Total 29/03/2020 44 12 66 30/03/2020 ...
Hi,
I think your solution is here, with LASTNONBLANK :
https://exceleratorbi.com.au/lastnonblank-explained/
Have a nice day
AilleryO
Memorable Member
Memorable MemberHi,
I think your solution is here, with LASTNONBLANK :
https://exceleratorbi.com.au/lastnonblank-explained/
Have a nice day
mdexResolver I
Resolver II'd found LASTNONBLANK already but couldn't figure out why it wasn't working.
Realised I'd got a number field set as TEXT!!!
Thanks