Forum Discussion

chocy's avatar
chocy
Frequent Visitor
7 years ago

LOOKUP DAX FUNCTION help please :(

Hi,   i neep help with a dax function   NATURAL ACCOUNT 3 IS PARENT OF NATRUAL ACCOUNT 4. BUT I WANT THE LOOKUP COLUMN TO SHOW ALL CHILDREN OF 550P EXCEPT 550K AS 550P…. AND ALSO LOOKUP AND SHOW ...
Need Help
v-cherch-msft's avatar
v-cherch-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

Hi chocy

 

It seems you may create the calculated column as below. If it is not your case, please explain more about your expected output and give more data sample.

Column =
IF (
    'CURRENT'[natural account lvl4] <> "550K"
        && 'CURRENT'[natural account lvl3] = "550P",
    'CURRENT'[natural account lvl3],
    'CURRENT'[natural account lvl4]
)

Regards,

Cherie

v-cherch-msft's avatar
v-cherch-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

Hi chocy

 

Could you tell me if your problem has been solved? If it is,kindly mark my answer as a solution if you feel that makes sense. Welcome to share your own solution. More people will benefit from here.

 

Regards,

Cherie