Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

VLOOKUP approximate 1

HI Everybody,

 

how can I replicate the VLOOKUP approximated (1 instead of 0) to power bi? I have a bunch of data and grouping is not possible no i need to assign a range closest as possbile.

 

Thanks ina dvance.

 

Regards,

AS

Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    7 years ago

    Hi Anonymous,

     

    Please refer to the attached .pbix file. I made some data transformation to 'Support' table in Query Editor, please pay attention to the applied steps. The 'Table1' is a calculated table that shows your expected output.

     

    Best regards,

    Yuliana Gu

3 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hi! 

       

      Thanks a lot. Here you can find a sample.

       

      Regards,

      AS

      • v-yulgu-msft's avatar
        v-yulgu-msft
        Icon for Microsoft Employee rankMicrosoft Employee
        7 years ago

        Hi Anonymous,

         

        Please refer to the attached .pbix file. I made some data transformation to 'Support' table in Query Editor, please pay attention to the applied steps. The 'Table1' is a calculated table that shows your expected output.

         

        Best regards,

        Yuliana Gu