Forum Discussion

pbiforum123's avatar
pbiforum123
Post Patron
6 years ago
Solved

Help required to implement security...

For one of my security requirement. I will have following table as input and thinking of following table as output but dont think that is the optimized way of doing it. For lesser number of records i...
Need Help
  • Mariusz's avatar
    Mariusz
    6 years ago

    Hi pbiforum123 

     

    Please see follow the steps in the video.


     

    Best Regards,
    Mariusz

    If this post helps, then please consider Accepting it as the solution.

    Please feel free to connect with me.
    LinkedIn

     

    Best Regards,
    Mariusz

    If this post helps, then please consider Accepting it as the solution.

    Please feel free to connect with me.
    LinkedIn

     

Mariusz's avatar
Mariusz
Community Champion
6 years ago

Hi pbiforum123 

 

You can create extra Table groups, like below

next, add a step to convert it to list.

and later you can use it in your code like below

#"Added Conditional Column" = Table.AddColumn(#"Replaced Value", "new group", each if [group] = null then groups else {[group]}),

 

 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

 

pbiforum123's avatar
pbiforum123
Post Patron
6 years ago

Mariusz Thanks a lot! I exactly did the same as I mentioned in my previous post I think you missed it out. I got some good understanding on M Script to start with. It is all because your help and assisstance. 

 

groups = List.RemoveNulls( List.Distinct( #"Replaced Value"[group] )),
groups1 = List.RemoveNulls( List.Distinct(group1[group1])),
#"Added Conditional Column" = Table.AddColumn(#"Replaced Value", "new group", each if [group] = null then groups1 else {[group]}),

 

Please share some tutorials if you have any about the M Script.