Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Need help Tableau to DAX

Hi, 

 

Can you help me convert this TABLEAU formula to DAX?: 

 

if [Status]= 'Added' then [Frequency]
else -1*[Frequency]
end

 

Many thanks! 

Need Help

6 Replies

  • Tahreem24's avatar
    Tahreem24
    Super User
    3 years ago

    Anonymous Create a dax like this:

     = IF(Table[Status] = "Added" , [Frequency],-1*[Frequency])

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Hi, 

      I started writing the same thing. However I am not able to select [Status] and [ Frequency] from this table. I can only select created measures from this table . 

      • Tahreem24's avatar
        Tahreem24
        Super User
        3 years ago

        Anonymous Are you using two different tables for this? If yes so make sure you have relationship between those tables.

        It would be great if you could share the sample data set of 5-10 records (dummy data) and expetcted output.