Table with Blank Rows

Question

Hi Everyone,&nbsp;Thank you in advance for your help. &nbsp;I'm farily new to Powerbi and had a question. &nbsp;&nbsp;I have a table where I need to have the blank rows be filled in with the main service listed on the PO. &nbsp;&nbsp;In the example below, PO 1 has a blank row, but I need that row to show as "hip" for modality, "total" for subtype, and "advanced hip" for the construct. &nbsp;PO 2's blank row should read knee, partial, and unicondylar. &nbsp;PO 3's blank rows should read shoulder, total, and reverse shoulder.&nbsp;Is there a DAX that can fill in the blank rows based off of the PO #?&nbsp; &nbsp;POModalitySubtypeConstruct1HipRevisionRevision1HipTotalAdvanced Hip1&nbsp;&nbsp;&nbsp;2KneePartialUnicondylar Knee2KneeOtherUpcharge2&nbsp;&nbsp;&nbsp;3ShoulderTotalReverse Shoulder3&nbsp;&nbsp;&nbsp;3&nbsp;&nbsp;&nbsp;

vahiddm · Answer

Hi&nbsp;Chipsahoy1&nbsp;&nbsp;Can you tell us the logic behind the selected items for the blank rows? and can you share a sample result or how you want to use those data?&nbsp;Appreciate your Kudos!!

chipsahoy1 · Answer

Hi&nbsp;VahidDM&nbsp;. &nbsp;Thanks for your quick response. &nbsp;The result I would like to get is below. &nbsp;The reasoning is because these are the major/main items for that PO. &nbsp;So for PO 1, the main item is listed on PO line #2. &nbsp;For PO #2, the major item is on line 1 and for PO #3, the major item is on line 1. &nbsp;&nbsp;The major items aren't always on PO line #s 1, 2, or 3. &nbsp;They could be on line #10, or 5. &nbsp;It all depends on who entered the info. &nbsp;So unfortunately the major item's PO line # is random.POPO Line#ModalitySubtypeConstruct11HipRevisionRevision12HipTotalAdvanced Hip13HipTotalAdvanced Hip21KneePartialUnicondylar Knee22KneeOtherUpcharge23KneePartialUnicondylar Knee31ShoulderTotalReverse Shoulder32Shoulder&nbsp;TotalReverse Shoulder33ShoulderTotalReverse ShoulderI'm open to suggestions on how this can be achieved. Would creating a separate table to only show the major components be an option (like below table)?PO&nbsp;Modality&nbsp;SubtypeConstruct1HipTotalAdvanced Hip2KneePartialUnicondylar&nbsp;3ShoulderTotalReverse Shoulder&nbsp;

anonymous · Answer

This can be achived in power query If you are ok with that. Or you want to do it with dax only?

samarth_18 · Answer

Hi&nbsp;Chipsahoy1&nbsp;,&nbsp;You can follow steps to get your desired output:-1. Go to trasform data tab, select your Modality,subtype and construct column and right click on it then select replace value option shown below:-2. Now put one space in "value to find" and add null in "Replace with"3. Now on the top ribbon click on "Fill" and select "Down"Below would be the final output and now click on close and apply:-&nbsp;Thank You,Samarth

vahiddm · Answer

Hi&nbsp;Chipsahoy1&nbsp;&nbsp;How can we find which PO line&nbsp;is the main? do you have any table like key table to find that?&nbsp;Appreciate your Kudos!!&nbsp;&nbsp;&nbsp;

Forum Discussion

Table with Blank Rows

8 Replies

Related content

PowerBI - Matrix table blanks

Blanks showing in table visual

Blank Page - Embedded Report

Counting Non-Blank Records

Table columns blank to right of blank field

PO	Modality	Subtype	Construct
1	Hip	Revision	Revision
1	Hip	Total	Advanced Hip
1
2	Knee	Partial	Unicondylar Knee
2	Knee	Other	Upcharge
2
3	Shoulder	Total	Reverse Shoulder
3
3

PO	PO Line#	Modality	Subtype	Construct
1	1	Hip	Revision	Revision
1	2	Hip	Total	Advanced Hip
1	3	Hip	Total	Advanced Hip
2	1	Knee	Partial	Unicondylar Knee
2	2	Knee	Other	Upcharge
2	3	Knee	Partial	Unicondylar Knee
3	1	Shoulder	Total	Reverse Shoulder
3	2	Shoulder	Total	Reverse Shoulder
3	3	Shoulder	Total	Reverse Shoulder

PO #	Modality	Subtype	Construct
1	Hip	Total	Advanced Hip
2	Knee	Partial	Unicondylar Knee
3	Shoulder	Total	Reverse Shoulder
4	Knee	Revision	Revision