Forum Discussion
Problem with formulea IF LOOKUPVALUE ?
Hi,
I would want to use a formulea to test data inside a field.
If the condition is true, I want to lookup the value from another table.
If the condition is false, I want to write a text.
I understand that Lookupvalue can return more than 1 value, but how can I change my formulea ?
Thank you,
Colonne =
IF
(
'public VSORDER'[VALBase]=True,
LOOKUPVALUE(
NbItemsInVal[NbItems],
NbItemsInVal[GME],
'public VSORDER'[GME]
),
"Other thing"
)
Mathais_ , change lookup with
Maxx(filter( NbItemsInVal, NbItemsInVal[GME] ='public VSORDER'[GME]) ,NbItemsInVal[NbItems])
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
2 Replies
- amitchandak
Super User
Mathais_ , change lookup with
Maxx(filter( NbItemsInVal, NbItemsInVal[GME] ='public VSORDER'[GME]) ,NbItemsInVal[NbItems])
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- Mathais_New Member
Thank you very much.
I'm bothered !
I'm an Excel expert, VBA expert and SQL developer, but PowerBI is very frustrating for me...
I don't understand the logical with this tool 😅