Thank you so much Phil! Both ways work fine!! Have a great day!
hi Mynda, Thank you for your kind reply! I couldn't solve it directly but will try again later. Right now I need to focus on solving other problems...
Thank you for your help! @Riny
Thanks Riny for your help! Indeed I had the same thought to have all data listed in the 'input' sheet so there is no need for the client to copy paste...
Thanks Mynda for your help! Indeed I saw people using VBA codes to get the overview but I was hoping there would be a build in way to do this. 🙂
I have another scenario with similar need but this one is easier to follow. So every month, I need to copy the formulas from last month (in the exampl...
Thank you Mynda for your help! The tricky part is that the dataset in power bi is connected with a direct sql query. I will have to contact IT to chan...
Thank you Riny for your help!
