Forum Discussion
IF Formula
Dear all,
I'm trying to get "Einzel" if the Document No is smaller than 300000 and "Vertrag" if the Document No is bigger than 300'000.
For the moment I only get "Einzel". My goal at the end is to use this measure als filter.
Thanks in advance for your inpouts:
- Einzel = IF(DISTINCTCOUNT('Service Order'[Document No])<300000, "Einzel", "Vertrag")
Try:
Einzel = IF ( SELECTEDVALUE ( 'Service Order'[Document No] ) < 300000, "Einzel", "Vertrag" )
2 Replies
Try:
Einzel = IF ( SELECTEDVALUE ( 'Service Order'[Document No] ) < 300000, "Einzel", "Vertrag" )Thank you PaulDBrown worked like a charm.