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)

Try using an IF statement:

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

Browse Categories

...