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
Hi,
I have a 2 tables like below:
Table 1:
Item | ID | Qty |
TV | 1002 | 4 |
TV | 1003 | 12 |
Table 2:
Item | ID | Stock Qty | Date |
TV | 1002 | 12 | 11.03.2021 |
TV | 1003 | 5 | 12.03.2021 |
TV | 1003 | 3 | 12.03.2021 |
In the Power BI Report I show the below table with ID as a Slicer:
when no selection is made on the slicer the table should appear as below by taking the sum of Quantity of table1 and max of date of table2 for the particular item.
Item | Qty | Date | StkQty |
TV | 16 | 12.03.2021 | 20 |
when ID=1002 is chose in the slicer the table should appear as below:
Item | Qty | Date | StkQty |
TV | 4 | 11.03.2021 | 12 |
Thanks in advance!
Solved! Go to Solution.
1. Make connection between Table 1 and Table 2 using ID
Create measures as following
QTY = SUM(table1[Qty])
StkQty = SUM(table2[StockQty])
Mxdate = MAX(table2[date])
when you create table visualization you will get results as follows
Regards,
Sayali
If this post helps, then please consider Accept it as the solution to help others find it more quickly.
Proud to be a Super User!
Hi, @AishwaryaS
Try to create 3 measures below:
_Sum of Qty = SUM('Table 1'[Qty])
_Sum of Stock Qty = SUM('Table 2'[Stock Qty])
_MaxDate = MAX('Table 2'[Date])
Result:
Is this the result you want? Hope this is useful to you
Please feel free to let me know If you have further questions
Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @AishwaryaS
Try to create 3 measures below:
_Sum of Qty = SUM('Table 1'[Qty])
_Sum of Stock Qty = SUM('Table 2'[Stock Qty])
_MaxDate = MAX('Table 2'[Date])
Result:
Is this the result you want? Hope this is useful to you
Please feel free to let me know If you have further questions
Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1. Make connection between Table 1 and Table 2 using ID
Create measures as following
QTY = SUM(table1[Qty])
StkQty = SUM(table2[StockQty])
Mxdate = MAX(table2[date])
when you create table visualization you will get results as follows
Regards,
Sayali
If this post helps, then please consider Accept it as the solution to help others find it more quickly.
Proud to be a Super User!
Join 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 |
---|---|
102 | |
97 | |
80 | |
62 | |
57 |
User | Count |
---|---|
264 | |
120 | |
115 | |
83 | |
70 |