Solved: VLOOKUP approximate 1

Anonymous · ‎10-12-2018

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

v-yulgu-msft · ‎11-05-2018

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

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

v-yulgu-msft · ‎10-14-2018

Hi @Anonymous,

Please illustrate your scenario with sample data and desired output.

How to Get Your Question Answered Quickly

Best regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous · ‎10-23-2018

Hi!

Thanks a lot. Here you can find a sample.

Regards,

AS

v-yulgu-msft · ‎11-05-2018

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

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

VLOOKUP approximate 1

Helpful resources

Fabric certifications survey

How to Get Your Question Answered Quickly