The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hello everyone,
I have a table with the following columns
I would like to filter this table with another table as the following using the column "Articolo"
So basically I would like to filter the first table only with the value of "Articolo" that are in the second table.
Can you help me?
Many thanks
Francesca
Hello.
I have this very question:
I have two related tables, one is called Pc (2) and the other Tasks (2), in the Pc table I have these fields: id_host_name (type ABC), user_name, First_name, model, Tags, Serial, Type, and in the Tasks table (2), you have these fields: id_host_name, of type ABC, date, hora_inicio, and hora_fin, of type date, usuario_wso, wifi, autologin, teamviewer, tag, dell command, bios_update, login_mdm, windows_update, reviewed, registered, are of type Yes/No.
I need to filter the quantity or name of the ordnenadores that are not yet loaded in the Tasks table (2), but if they appear in mim fact table Pc (2), know quantity and a list of the resulting id_host_name field.
Thanks a lot.
Hi @Fra4
In this caase you need to have a relationship between both tables with a 1-to-many.
Check the link below:
https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-create-and-manage-relationships
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsJoin the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
99 | |
93 | |
81 | |
63 | |
56 |
User | Count |
---|---|
248 | |
123 | |
111 | |
78 | |
74 |