Forum Discussion

Nightlight's avatar
Nightlight
New Member
8 years ago

IF+COUNTIF in POWERBI

Actually, I have met a problem about how to filter the special column by criterias.In Exccel,if+Countifs is easy. City             Transportation       Metro? Beijing        Air                    ...
Zubair_Muhammad's avatar
Zubair_Muhammad
Icon for Community Champion rankCommunity Champion
8 years ago

Nightlight

 

Hi

 

You can use this calculated column in Power BI

 

Column =
CONTAINS (
    FILTER ( Table1, Table1[City] = EARLIER ( Table1[City] ) ),
    [Transportation], "Metro"
)