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!
Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.
Mark your calendars and join us for our next Power BI Dev Camp!