Forum Discussion
Problem with formulea IF LOOKUPVALUE ?
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_ , 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
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 😅
