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
Tahreem24's avatar
Tahreem24
Icon for Super User rankSuper 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
      Icon for Super User rankSuper 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.

       

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        Hi, 

        No the table is one. I cannot attach a file here. In my data set the column [Status] is text, the column [Frequency] is number. I suppose I have to make some sort of aggregation?

        Here the table with the data. 

        Status Frequency
        Added -8
        Added 4.3
        Added -6.1
        Taken 10
        Taken 5.87
        Taken 7.23
        Taken -4.13
        Taken 0.5
        Taken -12
        Taken 8