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 Use this DAX:

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

Anonymous's avatar
Anonymous
Not applicable
3 years ago

With this formula I have the text column as a suggestion, but the column status is still not available from this table