Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Lookupvalue error with different values in columns Search_value/Search_column

Hi,   I've started looking into using Powerpivot/Powerquery/DAX in Excel 2 weeks ago approx. To start off I decided to basically recreate a existing Excel report using these tools. As if I get thi...
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Guys,

     

    Just played around with the last formula I had mentioned above and got the expected result (compared the result with data of two weeks in Excel with a positive result).

     

    =calculate(firstnonblank(ME80FN_hist[Purch.Doc.Item],1),filter(ME80FN_hist,Workflow_workload[Invoice Document No.]=ME80FN_hist[Material Document]))

     

    I've basically removed: all(ME80FN_hist[Purch.Doc.Item]) and just referred to the table as that is what the formula parameters suggested. Not sure what the goal of the all function was. Will dig into it when I come across it again.

     

     

    Hopefully this helps someone on their learning journey :).

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Guys,

 

Just played around with the last formula I had mentioned above and got the expected result (compared the result with data of two weeks in Excel with a positive result).

 

=calculate(firstnonblank(ME80FN_hist[Purch.Doc.Item],1),filter(ME80FN_hist,Workflow_workload[Invoice Document No.]=ME80FN_hist[Material Document]))

 

I've basically removed: all(ME80FN_hist[Purch.Doc.Item]) and just referred to the table as that is what the formula parameters suggested. Not sure what the goal of the all function was. Will dig into it when I come across it again.

 

 

Hopefully this helps someone on their learning journey :).