Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

difference between rows within a category

Hello, I am using power querry for data processing and I need help getting the difference between rows.  I have a table that has the following rows and columns: Country     Code    Region     Stage...
Need Help
edhans's avatar
edhans
Community Champion
6 years ago

Hi Anonymous 

 

Can you be a bit more specific? For example:

  1. You want Phase 3 to have an end date of 12/25/2025. What is a "phase?" You have no "Phase" columns.
  2. Where are you getting 12/25/2025? How is that being calculated?

I attaching more data, please see the guildlines for sample data below. The table you provided was not easy to get into a file.

How to Get Your Question Answered Quickly
How to provide sample data in the Power BI Forum

 

Greg_Deckler - I'm not Imke (not even close!), but there are a lot of us here to help on Power Query too. ğŸ˜Š

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    6 years ago
    Understood edhans. I'll have to add you to my macro invoking ImkeF ! ImkeF and I go way way back, I've been giving shout outs to her on Power Query questions for years! 🙂