Back

Explore Courses Blog Tutorials Interview Questions
0 votes
2 views
in BI by (17.6k points)
Does anyone know how to take one measure and split it into two new measures. So that the first measure will include only positive numbers, the second will contain only negative numbers.

1 Answer

0 votes
by (47.2k points)
edited by

Try using an IF statement:

IF {measure > 0} THEN 'Positive' ELSEIF {measure < 0} 'Negative' END

Make the right move by enrolling now in Tableau Online Course to learn it.

Browse Categories

...