Forum Discussion

Amaro's avatar
Amaro
Frequent Visitor
4 years ago
Solved

Fuzzy Merge - similarity score

Dears I'd like to have as an output of a fuzzy merge also the similarity score to apply some fine tuning to the algorithm. I saw on power query documentation there was an option to expand that value ...
Need Help
  • Vijay_A_Verma's avatar
    Vijay_A_Verma
    4 years ago

    Yes, that documentation should have noted that this is a feature available only for Power Query Online (app.powerbi.com). This feature is still not transported to Power BI Desktop / Power Query Excel. You need to be having at least Power BI Pro subscription to use Dataflows which will enable you to use PQ Online.

    See the snip from Power Query Online.

Amaro's avatar
Amaro
Frequent Visitor
4 years ago

thank you for your prompt reply.

I know about the option and using it.

What I would like to check if I can expand after the merge a column displaying the similarity score (please compare the MSFT documentation in my original post).


A

  • Vijay_A_Verma's avatar
    Vijay_A_Verma
    Most Valuable Professional
    4 years ago

    Yes, that documentation should have noted that this is a feature available only for Power Query Online (app.powerbi.com). This feature is still not transported to Power BI Desktop / Power Query Excel. You need to be having at least Power BI Pro subscription to use Dataflows which will enable you to use PQ Online.

    See the snip from Power Query Online.