Forum Discussion
Solved
Complex Query with Sharepoint Tables
Greetings! This is my first post here; hitting a snag with modeling my data and getting it into something that is helpful to decision-making. In my company, each of our positions require one or m...
Combine the WB Manpower and WB Personnel tables.
While you could merge them in Power Query that comes with a lot of baggage. I would recommend creating a calculated table with DAX.
Power BI is more akin to SSAS Tabular.
Combine the WB Manpower and WB Personnel tables.
They come from two different sources; so, is it an easy task to build queries and then "stack" them or combine them....? I guess I am trying to figure out, it Power BI closer to MS Access or SQL Server?
While you could merge them in Power Query that comes with a lot of baggage. I would recommend creating a calculated table with DAX.
Power BI is more akin to SSAS Tabular.