Forum Discussion

ksab23's avatar
ksab23
Helper I
3 years ago
Solved

Create new dataset with blanks

Hi All,  I was tasked to create a rather complex report that would showcase all users from a given list that participated in any of our offered videos. However, I was given two datasets - one t...
Need Help
Show and Tell
Tutorial Requests
  • olgad's avatar
    olgad
    3 years ago

    Hi there, 
    first replace Registration value yes with 1. 

    then pick a video title and pivot it

    Then merge two tables on the name

    Then expand it 

    Then replace null in all columns by referencing  that table

    let
    Source = #"Table",
    ReplaceNulls = Table.TransformColumns(Source,{},(x) => Replacer.ReplaceValue(x,null,0))
    in
    ReplaceNulls

     

     

     

    Hope that helps

     

     

v-jianboli-msft's avatar
v-jianboli-msft
Community Support
3 years ago

Hi ksab23 ,

 

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or if you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file after removing sensitive data.

 

Refer to:

How to provide sample data in the Power BI Forum

How to Get Your Question Answered Quickly

 

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.