Removing data from a table using another as filter

[ErickReiis]

Good morning people, everything fine?

I need help getting data from a table based on another table.

I have a table of doctors where they are registered, and I have a Blacklist of doctors who should not be part of my analysis. I've tried to do an inner Join but it gives an error and says that it was not possible to convert a value of type Int to text.

Is it possible to do this with DAX?

[v-zhangti · Accepted solution]

Hi, @ErickReiis 

If you are converting data of type int to text, you can try the FORMAT function.

https://docs.microsoft.com/dax/format-function-dax 

As an example.

Column = FORMAT([Value],"")

Hope this can help you.

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@ErickReiis , Merge in power query

Append & merge : https://radacad.com/append-vs-merge-in-power-bi-and-power-query

Join in DAX

https://www.sqlbi.com/articles/from-sql-to-dax-joining-tables/

We can also copy columns, in one of the 4 ways

refer 4 ways to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8