Forum Discussion
Path error - value in source must also exist in dest
Hi all, I want to make a path column to filter on. The issue is that everytime new data is generated, all the new dest and source are paired, but the IDs generated in the dest will never be the s...
Hi, radiator
You can create a mapping table that keeps track of the relationship between source and destination IDs. This way, you can always refer to the mapping table to find the corresponding destination ID for a given source ID. You can share the pbix file without sensitive data and the effect you want to achieve, which might help you solve the problem faster.
Best Regards,
Yang
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum