Forum Discussion

ksab23's avatar
ksab23
Icon for Helper I rankHelper 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

     

     

olgad's avatar
olgad
Icon for Resident Rockstar rankResident Rockstar
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