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] )

3 Replies

    • 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] )