Anyone knows how I can fullfill my measure that I am trying to work as the following
if PVoT Days <= 0 then return 1 (true) else 0 (false)
if PVoT Days has Blank value then retun 0
if PVoT Days >= 1 then return 0 (false)
In the screenshot you can see that my measure works for the 2 first statment, how can i add the 3rd statment (if PVoT is >= 1 then return 0)?
Go to Solution.
@jalaomar Use SWITCH function:
View solution in original post
Hi @Marik, the measure is working perfectly
Many thanks for the support! 🙂
Click here to read more about the December 2021 Updates!
Mark your calendars and join us for our next Power BI Dev Camp!
Learn how to create your own user groups today!