Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

VLOOKUP from Excel to Power Bi

Hi Everyone,    I am recently new to Power BI and I am struggling on a project. I am trying to use LOOKUPVALUE but can't seem to figure it out. I have confidential data, so I've created example tab...
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    4 years ago

    Hi, Anonymous ;

    You could create two measures about it.

    Sum in = CALCULATE(SUM('Sales Table'[Net Revenue]),FILTER('Sales Table',[Material] in VALUES('Detail Only Code'[Material Code])))
    Customersum =
CALCULATE (
    SUM ( 'Sales Table'[Net Revenue] ),
    FILTER (
        'Sales Table',
        [Customer]
            IN SUMMARIZE (
                FILTER (
                    'Sales Table',
                    [Material] IN VALUES ( 'Detail Only Code'[Material Code] )),
                [Customer])))

    The final output is shown below:


    Best Regards,
    Community Support Team_ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-yalanwu-msft's avatar
v-yalanwu-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi, Anonymous ;

You could create two measures about it.

Sum in = CALCULATE(SUM('Sales Table'[Net Revenue]),FILTER('Sales Table',[Material] in VALUES('Detail Only Code'[Material Code])))
Customersum =
CALCULATE (
    SUM ( 'Sales Table'[Net Revenue] ),
    FILTER (
        'Sales Table',
        [Customer]
            IN SUMMARIZE (
                FILTER (
                    'Sales Table',
                    [Material] IN VALUES ( 'Detail Only Code'[Material Code] )),
                [Customer])))

The final output is shown below:


Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.