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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

Curating data inside of a Power BI report...

Hi All,

I have a customer who wants to replace blanks in column cells with data from another cell where they share the same key value inside of another cell. I am assuming Power BI through creating a new custom column can do this?

 

I think the experts might find this interesting.

Thanks!

1 ACCEPTED SOLUTION
Greg_Deckler
Super User
Super User

Yes it can, would need sample data to be specific but general form is:

 

Column = IF(ISBLANK([Other Column]),[Some Other Column],[Other Column])


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

5 REPLIES 5
Greg_Deckler
Super User
Super User

Yes it can, would need sample data to be specific but general form is:

 

Column = IF(ISBLANK([Other Column]),[Some Other Column],[Other Column])


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...
Anonymous
Not applicable

Ok.

If company name is blank but if there is another record with a common key say groupid then get the record's company name and fill in the blank with the company name from that.

 

Company Name    groupid

microsoft                    10

microsoft                    10

blank                              10

 

then fill in the blank using the groupid

 

microsoft                   10

microsoft                   10

microsoft                   10

Anonymous
Not applicable

Ok. I wonder if an AI could do this filling in the blanks? I appreciate the answer will try in out but I do wonder about the AI.

 

Thanks!

You could try it in Power Query by creating a column from examples, it might figure it out but it tends to be hit or miss.


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...
Anonymous
Not applicable

I agree. Since most AI's use probability to provide insights it sometimes is no better than flipping a coin. I have worked with AI so I know that to be true.

 

Thanks!

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.