Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I want to achieve a calculated colum(boolean) when comparing the tableA and TableB. Table C is a dynamic table with combinations of country origin and destination, what I want is when the country origin from tableA = NULL OR country_origin in table C AND country_destination table B = country_destination table C, then print YES, else NO. Table C doesnt have a relationship with table A or table B. How can i achieve this in PowerBI?
language alone is sometimes not very logical. try to provide some data sample with expected result.
User | Count |
---|---|
98 | |
90 | |
77 | |
71 | |
64 |
User | Count |
---|---|
114 | |
98 | |
96 | |
68 | |
67 |