Pro Power BI Desktop by Adam Aspin

Pro Power BI Desktop by Adam Aspin

Author:Adam Aspin
Language: eng
Format: epub
Publisher: Apress, Berkeley, CA


Operator

Description

Example

IF()

Tests a condition and applies a result if the test is true, and possibly a result if the test is false.

IF([PartsCost]> 500, "Check Parts", "OK")

AND()

Extends the logic to include several conditions all of which must be met.

IF(AND([PartsCost]> 500,[LaborCost]>1000), "Repair Cost Excessive", "OK")

OR()

Extends the logic to include several conditions any of which must be met.

IF(OR([PartsCost]> 500,[LaborCost]>1000), "Repair or Labor Cost issue", "OK")



Download



Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.