The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Input
Week_ID | Period | Item | Value |
1 | Pre-Pilot | A | XXXXX1 |
2 | Pre-Pilot | A | XXXXX2 |
1 | Pre-Pilot | C | XXXXX3 |
3 | Pre-Pilot | D | XXXXX4 |
3 | Pre-Pilot | A | XXXXX5 |
4 | Pre-Pilot | B | XXXXX6 |
5 | Pre-Pilot | B | XXXXX7 |
5 | Pre-Pilot | A | XXXXX8 |
4 | Pre-Pilot | C | XXXXX9 |
6 | Pilot | D | XXXXX10 |
6 | Pilot | A | XXXXX11 |
7 | Pilot | A | XXXXX12 |
8 | Pilot | D | XXXXX13 |
Select Week_ID for Pre-pilot 1,2,3,4,5 and Pilot 6 from two seperate slicers.
Requirement
I need to create a single table values for Pre-Pilot selected period ( 1, 2, 3, 4, 5 ) for only items ( A, D ) which selected within Pilot period.
Can anyone advise how can I create below output according to the above requirements.
Output
Week_ID | Period | Item | Value |
1 | Pre-Pilot | A | XXXXX1 |
2 | Pre-Pilot | A | XXXXX2 |
3 | Pre-Pilot | D | XXXXX4 |
3 | Pre-Pilot | A | XXXXX5 |
5 | Pre-Pilot | A | XXXXX8 |