How to create categories with different columns and tables

[Anonymous]

Hi, I need to create categories with certain columns that can be either columns from the same table, or columns from different and concatenated tables. Something like:
Suppliers:
- column A from table A
- column B+column C from table X
- column D from table A

I'm importing data and tabled with direct query

Thank you!

[_AAndrade · Accepted solution]

Hi @Anonymous,

Why don't you create a view with this logic and after use that query no import data to power BI?

[Anonymous]

i'm trying so, thank you

[_AAndrade]

If you need any help please let me know. And at the end please tell me if this solved your problem