Forum Discussion

Zengiy's avatar
Zengiy
New Member
3 years ago

Need help to get hourly target

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.

Need Help

2 Replies

  • mussaenda's avatar
    mussaenda
    Community Champion
    3 years ago

    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

  • Zengiy's avatar
    Zengiy
    New Member
    3 years ago
     

     

     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.