Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Calculated column. 3 different tables IF/ CASE statement

  Hello,    I am trying to create a calculated column between 3 different tables. All 3 tables are connected on a filed called 'ITEMID' field. Does someone know how to write it correctly please? ...
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

Anonymous , You have bring other column this table using one of the 4 ways. You can bring them in var of the column

 

refer 4 ways (related, relatedtable, lookupvalue, sumx/minx/maxx with filter) to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8

 

The syntax of if in power bi Dax id 

 

If(<Condition>, <Then>, <else>)

 

You can use switch

Switch-Case statement of #PowerBI: https://www.youtube.com/watch?v=gelJWktlR80&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=56

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Thank you.