Create a Table based on Multiple Criteria

Sana Shaikh 0 Reputation points
2024-01-24T15:26:31.5366667+00:00

Hello All,
I am a Power BI developer and I have come across a problem that I need help solving. I want to create a table based on multiple criteria. I am doing a drill through from one page to another, where I can see the details of feedback that occurred on that day. I have 3 tables and I need to pull values from columns that are not connected to each other but are connected to a mutual table that pulls the value for all dates. This is what I have so far in Power BI, I have put it into Excel for privacy. I am able to create 3 different tables based on the criteria I need. User's image

My desired outcome would be:

User's image

If I am on page 1 and I drill through on the Submitted Score DT then page 2 will pull up the table to show which Driver was driving which bus on that day and the individual scores given per item.

Can anyone help?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,234 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,515 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Erland Sommarskog 98,751 Reputation points
    2024-01-24T22:55:18.28+00:00

    Power BI questions are better asked here: https://community.powerbi.com/t5/Forums/ct-p/PBI_Comm_Forums

    0 comments No comments