Strength bi “in the event the statement” is straightforward to implement inside DAX. It truly does work the same as when the-otherwise in the SQL. The brand new syntax regarding if the report from inside the dax is actually

When your productivity of your logical_decide to try is valid, then it screens next parameter, and if it’s false, up coming view the 3rd factor.

It’s important to remember that one another well worth_if_true and cost_if_not the case need an equivalent investigation sort of; if you don’t, it can toss a blunder.

You can see this new scholar “marks” desk with different articles. We try to help make you to definitely personalized line called “Groups” into the following the dax term.

DAX nested when the statement during the Fuel BI

Let us relocate to the advantage bi nested when the declaration execution. We will have an identical studies desk which you have viewed above.

Contained in this dax algorithm, i have utilized a couple if comments. First, we are researching if the acquired scratching column has actually a respect out of below 60. It will get back degree C. If for example the conditions return not true, upcoming the audience is composing once more an additional in the event the report that assesses if the “obtained marks” is actually less than 70, this may be reveals degree B if not degree A beneficial as you can pick below. Leia mais