Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
JawaharPrem6
Helper I
Helper I

Delete Blank rows after lookupvalue

Hi Team,

 After lookupvalue with both tables i need to remove the blank rows its possible.

 

 

Crt_Name = LOOKUPVALUE(
    Crt_Name[Correct_Name],Crt_Name[Created By],ZMM[Created By]
    )

 

Thanks

Jawahar

1 ACCEPTED SOLUTION
smpa01
Super User
Super User

@JawaharPrem6  if you want to delete blank rows after LOOKUPVALUE, you need to create a derived table that would not have BLANK Rows. You would not be able to utilize LOOKUPVALUE on the same table and have it filtered as well. But you can create a derived/calculated table like this

 

FILTER(ADDCOLUMNS(ZMM,"Crt_Name", LOOKUPVALUE(Crt_Name[Correct_Name],Crt_Name[Created By],ZMM[Created By])),[Crt_Name]<>BLANK())

 

 

However, LOOKUPVALUE has severe performance implication. I would do it this way

 

GENERATE(ZMM,SELECTCOLUMNS(FILTER(Crt_Name,Crt_Name[Created By]=ZMM[Created By]),Crt_Name[Correct_Name]))

 

 

Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
My custom visualization projects
Plotting Live Sound: Viz1
Beautiful News:Viz1, Viz2, Viz3
Visual Capitalist: Working Hrs

View solution in original post

2 REPLIES 2
smpa01
Super User
Super User

@JawaharPrem6  if you want to delete blank rows after LOOKUPVALUE, you need to create a derived table that would not have BLANK Rows. You would not be able to utilize LOOKUPVALUE on the same table and have it filtered as well. But you can create a derived/calculated table like this

 

FILTER(ADDCOLUMNS(ZMM,"Crt_Name", LOOKUPVALUE(Crt_Name[Correct_Name],Crt_Name[Created By],ZMM[Created By])),[Crt_Name]<>BLANK())

 

 

However, LOOKUPVALUE has severe performance implication. I would do it this way

 

GENERATE(ZMM,SELECTCOLUMNS(FILTER(Crt_Name,Crt_Name[Created By]=ZMM[Created By]),Crt_Name[Correct_Name]))

 

 

Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
My custom visualization projects
Plotting Live Sound: Viz1
Beautiful News:Viz1, Viz2, Viz3
Visual Capitalist: Working Hrs
lbendlin
Super User
Super User

Is this a Power Query or DAX question?

 

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors
Top Kudoed Authors