Forum Discussion

FirstPeace's avatar
FirstPeace
Regular Visitor
4 years ago
Solved

Passing a column name as the parameter selection

Hi,   I have a need where the filter condition Column_name <> null has to be passed through the    = Table.SelectRows(Sales, each ([sold_to] <> null) )   I have columns in the fact as sold_to, ...
Need Help
  • Vijay_A_Verma's avatar
    Vijay_A_Verma
    4 years ago

    Use this

    = Table.SelectRows(Sales, each (Record.Field(_,your parameter name)<> null) )

    Change your parameter name appropriately. 

Vijay_A_Verma's avatar
Vijay_A_Verma
Most Valuable Professional
4 years ago

Use this

= Table.SelectRows(Sales, each (Record.Field(_,your parameter name)<> null) )

Change your parameter name appropriately.