Forum Discussion

asdf1608's avatar
asdf1608
Helper V
3 years ago
Solved

Need help with DAX

How to get this calculated field from Tableau to Power BI.   if [Order Set]  then [Customer Name] else "" end
  • johnt75's avatar
    johnt75
    3 years ago

    Ah, OK. Then you can create a column like

    New column =
IF ( NOT ISBLANK ( 'Table'[Order set] ), 'Table'[Customer name] )
johnt75's avatar
johnt75
Super User
3 years ago

Use Power Query to add a Conditional Column.

asdf1608's avatar
asdf1608
Helper V
3 years ago

Yes, But the calculated column/ sets cannot be used in Power Query editor right. 

Here order set is a group created in Power BI

  • johnt75's avatar
    johnt75
    Super User
    3 years ago

    Ah, OK. Then you can create a column like

    New column =
IF ( NOT ISBLANK ( 'Table'[Order set] ), 'Table'[Customer name] )