論理関数

Power BI DAX中級

Carl Rosseel

Curriculum Manager

論理関数の概要

論理関数とは、ある式に含まれる値や集合などの情報を返す処理をする関数

主な論理関数：

IF()
AND(), OR(), NOT()
SWITCH()

よく使われる論理関数：IF()

構文：

IF(<logical_test>, <value_if_true>, <value_if_false>)

例：

Performance = IF([Total Sales] >= 50 000, "Target Reached", "Target Not Reached")

よく使われる論理関数：IF()

構文：

IF(<logical_test>, <value_if_true>[, <value_if_false>])

例:

Performance = IF([Total Sales] >= 50 000, "Target Reached", "Target Not Reached")

Name	Total Sales
Jenny	48,431
Jane	76,528
Dwayne	24,167
Thomas	52,125

よく使われる論理関数：IF()

構文：

IF(<logical_test>, <value_if_true>[, <value_if_false>])

例:

Performance = IF([Total_Sales] >= 50 000, "Target Reached", "Target Not Reached")

Name	Total Sales	Performance
Jenny	48,431	Target not Reached
Jane	76,528	Target Reached
Dwayne	24,167	Target Not Reached
Thomas	52,125	Target Reached

AND()・ OR() ・NOT() 演算子

この3つの演算子は、TRUEまたはFALSEの結果を返す

AND(<logical1>,<logical2>)
- 両方の条件がTRUEの場合、TRUEを返す
- 例：AND(5 < 4, 5 < 6) = AND(FALSE, TRUE) = FALSE
OR(<logical1>,<logical2>)
- 少なくとも1つの条件がTRUEの場合、TRUEを返す
- 例：OR(5 < 4, 5 < 6) = OR(FALSE, TRUE) = TRUE
NOT(<logical>)
- TRUEをFALSEに、FALSEをTRUEに変換する
- 例：NOT(OR(5 < 4, 5 < 6)) = NOT(TRUE) = FALSE

AND()・ OR() ・NOT() 演算子

ANDは&&に置き換え可能

AND(5 < 4, 5 < 6) = 5 < 4 && 5 < 6

ORは|| に置き換え可能

OR(5 < 4, 5 < 6) = 5 < 4 || 5 < 6

SWITCH()の力

式を値のリストと照合し、複数の結果式から該当するものを返す。

SWITCH(<expression>, <value>, <result>[, <value>, <result>] ... [, <else>])

IF()関数をネストするよりも好まれることが多い

Performance = SWITCH(TRUE, 
[Total_Sales] < 25 000, "Poor",
[Total_Sales] < 50 000, "Below expectations",
[Total_Sales] < 75 000, "Above expectations",
"Exceptional")

SWITCH()の力

Performance = SWITCH(TRUE, 
[Total_Sales] < 25 000, "Poor",
[Total_Sales] < 50 000, "Below expectations",
[Total_Sales] < 75 000, "Above expectations",
 "Exceptional")

Name	Total Sales
Jenny	48,431
Jane	76,528
Dwayne	24,167
Thomas	52,125

SWITCH()の力

Performance = SWITCH(TRUE, 
[Total_Sales] < 25 000, "Poor",
[Total_Sales] < 50 000, "Below expectations",
[Total_Sales] < 75 000, "Above expectations",
 "Exceptional")

Name	Total Sales	Performance
Jenny	48,431	Below Expectations
Jane	76,528	Exceptional
Dwayne	24,167	Poor
Thomas	52,125	Above expectations

SWITCH()の力

DISCOUNT = SWITCH([Clothing Type], 
               "Shoes", 0.15,   
               "Pants", 0.20,
               "Belts", 0.30, 
               "T-shirt", 0.25)

Clothing Type
Shoes
Pants
Belt
T-shirt

SWITCH()の力

DISCOUNT = SWITCH([Clothing Type], 
               "Shoes", 0.15,   
               "Pants", 0.20,
               "Belts", 0.30, 
               "T-shirt", 0.25)

Clothing Type	Discount
Shoes	15%
Pants	20%
Belt	30%
T-shirt	25%

練習しましょう！

Power BI DAX中級