Error in Dax Studio for a simple LOOKUPVALUE

up vote
0
down vote

favorite

I am new to PBI and DAX. I am using Dax Studio to explore some functions. I am trying to do a look up value on a simple table. The table is Users and it has 2 columns, Name and ClientID. This is my DAX formula that I have in the Studio editor

LOOKUPVALUE(Users[ClientID], [Name], "john smith")

When I run it I get this output

enter image description here

Thank you in advance

asked Nov 12 at 17:33

Jake

1018

add a comment |

up vote
0
down vote

favorite

LOOKUPVALUE(Users[ClientID], [Name], "john smith")

When I run it I get this output

enter image description here

Thank you in advance

asked Nov 12 at 17:33

Jake

1018

add a comment |

up vote
0
down vote

favorite

LOOKUPVALUE(Users[ClientID], [Name], "john smith")

When I run it I get this output

enter image description here

Thank you in advance

asked Nov 12 at 17:33

Jake

1018

LOOKUPVALUE(Users[ClientID], [Name], "john smith")

When I run it I get this output

enter image description here

Thank you in advance

powerbi dax

asked Nov 12 at 17:33

Jake

1018

asked Nov 12 at 17:33

Jake

1018

asked Nov 12 at 17:33

Jake

1018

asked Nov 12 at 17:33

Jake

1018

asked Nov 12 at 17:33

Jake

1018

add a comment |

1 Answer
1

active

oldest

votes

up vote
2
down vote

accepted

I'm guessing it wants a fully qualified column name.

Try this:

LOOKUPVALUE(Users[ClientID], Users[Name], "john smith")

Edit:

DAX Studio generally expects table output rather than measure output. You can get around this by turning your value into a table.

Try this:

EVALUATE {LOOKUPVALUE(Users[ClientID], Users[Name], "john smith")}

edited Nov 12 at 18:45

answered Nov 12 at 18:01

Alexis Olson

11.3k21633

Thank you for the suggestion. I tried this and I am getting the same error. When I create a column in PBI desktop and input the formula there it all works fine. I am just trying to figure out how to use DAX Studio. I would prefer not to make a column when I test functions. I was hoping I could use DAX Studio as a playground to test around in
– Jake
Nov 12 at 18:29

Please see my edit.
– Alexis Olson
Nov 12 at 18:45

add a comment |

Your Answer

StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});

}
});

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53267290%2ferror-in-dax-studio-for-a-simple-lookupvalue%23new-answer', 'question_page');
}
);

Post as a guest

Name

Required, but never shown

1 Answer
1

active

oldest

votes

1 Answer
1

active

oldest

votes

up vote
2
down vote

accepted

I'm guessing it wants a fully qualified column name.

Try this:

LOOKUPVALUE(Users[ClientID], Users[Name], "john smith")

Edit:

DAX Studio generally expects table output rather than measure output. You can get around this by turning your value into a table.

Try this:

EVALUATE {LOOKUPVALUE(Users[ClientID], Users[Name], "john smith")}

edited Nov 12 at 18:45

answered Nov 12 at 18:01

Alexis Olson

11.3k21633

Thank you for the suggestion. I tried this and I am getting the same error. When I create a column in PBI desktop and input the formula there it all works fine. I am just trying to figure out how to use DAX Studio. I would prefer not to make a column when I test functions. I was hoping I could use DAX Studio as a playground to test around in
– Jake
Nov 12 at 18:29

Please see my edit.
– Alexis Olson
Nov 12 at 18:45

add a comment |

up vote
2
down vote

accepted

I'm guessing it wants a fully qualified column name.

Try this:

LOOKUPVALUE(Users[ClientID], Users[Name], "john smith")

Edit:

DAX Studio generally expects table output rather than measure output. You can get around this by turning your value into a table.

Try this:

EVALUATE {LOOKUPVALUE(Users[ClientID], Users[Name], "john smith")}

edited Nov 12 at 18:45

answered Nov 12 at 18:01

Alexis Olson

11.3k21633

Thank you for the suggestion. I tried this and I am getting the same error. When I create a column in PBI desktop and input the formula there it all works fine. I am just trying to figure out how to use DAX Studio. I would prefer not to make a column when I test functions. I was hoping I could use DAX Studio as a playground to test around in
– Jake
Nov 12 at 18:29

Please see my edit.
– Alexis Olson
Nov 12 at 18:45

add a comment |

up vote
2
down vote

accepted

I'm guessing it wants a fully qualified column name.

Try this:

LOOKUPVALUE(Users[ClientID], Users[Name], "john smith")

Edit:

DAX Studio generally expects table output rather than measure output. You can get around this by turning your value into a table.

Try this:

EVALUATE {LOOKUPVALUE(Users[ClientID], Users[Name], "john smith")}

edited Nov 12 at 18:45

answered Nov 12 at 18:01

Alexis Olson

11.3k21633

I'm guessing it wants a fully qualified column name.

Try this:

LOOKUPVALUE(Users[ClientID], Users[Name], "john smith")

Edit:

DAX Studio generally expects table output rather than measure output. You can get around this by turning your value into a table.

Try this:

EVALUATE {LOOKUPVALUE(Users[ClientID], Users[Name], "john smith")}

edited Nov 12 at 18:45

answered Nov 12 at 18:01

Alexis Olson

11.3k21633

edited Nov 12 at 18:45

answered Nov 12 at 18:01

Alexis Olson

11.3k21633

answered Nov 12 at 18:01

Alexis Olson

11.3k21633

answered Nov 12 at 18:01

Alexis Olson

11.3k21633

Thank you for the suggestion. I tried this and I am getting the same error. When I create a column in PBI desktop and input the formula there it all works fine. I am just trying to figure out how to use DAX Studio. I would prefer not to make a column when I test functions. I was hoping I could use DAX Studio as a playground to test around in
– Jake
Nov 12 at 18:29

Please see my edit.
– Alexis Olson
Nov 12 at 18:45

add a comment |

Thank you for the suggestion. I tried this and I am getting the same error. When I create a column in PBI desktop and input the formula there it all works fine. I am just trying to figure out how to use DAX Studio. I would prefer not to make a column when I test functions. I was hoping I could use DAX Studio as a playground to test around in
– Jake
Nov 12 at 18:29

Please see my edit.
– Alexis Olson
Nov 12 at 18:45

Thank you for the suggestion. I tried this and I am getting the same error. When I create a column in PBI desktop and input the formula there it all works fine. I am just trying to figure out how to use DAX Studio. I would prefer not to make a column when I test functions. I was hoping I could use DAX Studio as a playground to test around in
– Jake
Nov 12 at 18:29

Please see my edit.
– Alexis Olson
Nov 12 at 18:45

add a comment |

draft saved

draft discarded

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Name

Required, but never shown

Name

Required, but never shown

This page is only for reference, If you need detailed information, please check here

搜尋此網誌

Cfrgtkky