Need help to get hourly target

[Zengiy]

Hi All Experts,

I am trying to link my hourly target to my hourly output. The problem is that my data server has the data for my hourly output, but there is only a daily target for my target. How can I use power query to merge so that I can get an hourly output as well.

[Zengiy]

 Hi mussaenda,

Thanks for your reply. That was the very first thing I tried doing, and I created 24 new columns. The issue would be I........

Nvm, while typing this reply, a spark suddenly came to me on how I MAY solve this issue. Thanks once again for your reply. Greatly appreciated!

thanks for your reply. I did think about doing that, but by doing that, I will have 24 new columns and it would be difficult to tag it to what I need to show.

[mussaenda]

Hi @Zengiy ,

just an idea, how about you divide your daily target to total hours you need so you will have an hourly target?

Hope this helps