Forum Discussion

Kohrinn's avatar
Kohrinn
Icon for Helper I rankHelper I
3 years ago
Solved

Pie chart + measure?

Hi, I have a table, where I keep the start and end dates of Events and SubEvents. I assume, that Event starts when first SubEvent starts and ends when the last SubEvent ends. There are gaps between...
Need Help
  • Sergii24's avatar
    Sergii24
    3 years ago

    Take a closer look at *.pbix file. "Idle" subevent is automatically added to each event in PowerQuery, so you don't need to it manually 😉

Kohrinn's avatar
Kohrinn
Icon for Helper I rankHelper I
3 years ago

It looks really promising - one question though. Is it any way around adding "Idle" subevent to every event? I have like hundreds of Events now and they are still coming so adding manually "Idle" is not a solution. ☹️

Sergii24's avatar
Sergii24
Icon for Super User rankSuper User
3 years ago

Take a closer look at *.pbix file. "Idle" subevent is automatically added to each event in PowerQuery, so you don't need to it manually 😉

  • Kohrinn's avatar
    Kohrinn
    Icon for Helper I rankHelper I
    3 years ago

    Thank you! 😄

  • Kohrinn's avatar
    Kohrinn
    Icon for Helper I rankHelper I
    3 years ago

    I tried it and I can't find the piece of code where "Idle" is added to each event automatically 😓

    I've copied your caclulations and nothing happened ☹️

    • Sergii24's avatar
      Sergii24
      Icon for Super User rankSuper User
      3 years ago

      Hi Kohrinn, before copy-paste code from PowerQuery try to better understand it. I haven't seen your data, so you should first understand the proposed logic in that example, then compare the initial table with your and perfrom modificaitons step-by-step. To help you further I would need more details on what you've tried, what do you struggle with and sample of your raw data. Let me know if any help is needed!