Forum Discussion

ERICCFG's avatar
ERICCFG
Frequent Visitor
2 years ago

Power BI Formule SWITH

Why this formula does not work, It looks at the condition, if it is true if it will look for the values ​​in the table (day number) compare it smaller to... if yes, zero, if not I take the valu...
Show and Tell
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi ERICCFG 

 

PijushRoy Thank you very much for your prompt reply, please allow me to share some content here.

 

For your question, here is the method I provided:

 

 

Create a measure.

 

NB JOURS = 
var _status = SELECTEDVALUE('MAINT_WORK_REQUEST_V'[STATUS])
var _Nombre = SELECTEDVALUE('MAINT_WORK_REQUEST_V'[Nombre de jours])
RETURN
SWITCH(
    TRUE(),
    _status = "Urgent" && _Nombre < 1, _Nombre,
    _status = "Pressant" && _Nombre >= 3, _Nombre,
    _status = "Au cours de la semaine" && _Nombre >= 8, _Nombre,
    _status = "Au cours du mois" && _Nombre >= 31, _Nombre,
    0
)

 

Here is the result.

 

 

Regards,

Nono Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.