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

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!