Explore Courses Blog Tutorials Interview Questions
0 votes
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