Forum Discussion

Helper II

9 years ago

percentages and multiple query columns

I'm new to Power BI and having a difficulty applying what I'm learning through the hours of tutorials to my particular situation, so your help is greatly appreciated. Our company rents instrument...

Helper II

9 years ago

I'm guessing that this would be an ideal time for a drill down. The main visualization would be those returned versus those owned, while the drill down would occur once selecting "owned", revealing the percentage of early payoff's versus those who rented all the way to ownership.

kincaids
Helper II
9 years ago
*bump*
- Greg_Deckler
  Community Champion
  9 years ago
  kincaids - To get this question answered, you need to post some sample data that is not a picture and then the result that you would expect from that sample data. That way it is easy to recreate your issue and find a solution.
  - kincaids
    Helper II
    9 years ago
    I know these are pictures, but I hope this is what you're looking for.
    
    currently renting - 7/15
    returns - 4/15 (return dates)
    own instrument - 4/15 (null & X)
    
    of the owned instruments:
    rented until owned - 1/15 (row 4 - "next pmt #" = "terms")
    took early pay-off discount - 3/15 (rows 7, 9, 10 - "nxt pmt #" < "terms")
    
    So, I would hope to see in this data that 46.66% are currently renting, 26.67% have returned their instrument, and 26.67 own their instrument.
    
    When drilling down into those that own their instrument, I would expect to see that 25% rented until they owned and 75% took the early pay-off discount (or that 6.67% of all renters rented until they owned and 20% of all renters take the early pay-off discount). I hope this helps.