Forum Discussion
Table with Blank Rows
Hi Everyone, Thank you in advance for your help. I'm farily new to Powerbi and had a question. I have a table where I need to have the blank rows be filled in with the main service listed ...
Hi Chipsahoy1
How can we find which PO line is the main? do you have any table like key table to find that?
Appreciate your Kudos!!
VahidDM Unfortunately not, but there are keywords that I know are not the main components. for subtype and construct. The keywords like "revision" and "other" for subtype and "revision", and "upcharge" for construct. What makes this a bit trickier is, a revision can be a main component if there no other components are listed on that PO (see below).
| PO # | PO Line # | Modality | Subtype | Construct |
4 | 1 | |||
| 4 | 2 | Knee | Revision | Revision |
So for the example above, I would need it to eventually show as this.
| PO # | PO Line # | Modality | Subtype | Construct |
4 | 1 | Knee | Revision | Revision |
| 4 | 2 | Knee | Revision | Revision |